![]() ![]() The index is re-created each time the sheet that houses the code is activated. ![]() The following code will automatically create a clickable, hyperlinked index of all the sheets you have in the workbook. Although this method is probably sufficient for limited instances in which you don't have too many sheets and they won't change often, you'll be stuck maintaining your index by hand. Create a new worksheet, call it Index or the like, enter a list of all your worksheet's names, and hyperlink each to the appropriate sheet by selecting Insert ยป Hyperlink. You might be tempted to simply create the index by hand. You can create an index in a couple of ways. ![]() Using an index sheet will enable you to quickly and easily navigate throughout your workbook so that with one click of the mouse, you will be taken exactly where you want to go, without fuss. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |