Bookmark in Excel

[SHAWTY721]

I was wondering can bookmarks be added to Microsoft Excel spreadsheets so that you can have an index tab that will list all the tabs that are included in the worksheet. Similar to the bookmarks that can be created in Microsoft Word.

 

[SkipVought]

Hi,

Try Right-Clicking the Tab Navigation controls in the lower left-hand of the Excel Window.

Skip,
[sub]
Just traded in my old subtlety...
for a brand NUANCE![/sub]

 

[Gavona]

Taking things a step further, you can create an index sheet by:
Insert, Hyperlink, Places in this document.......

Personally I did this with the macro recorder on and tweaked the results so I run the macro and it produces a list of the sheets in the workbook. The hyperlink will take you to cell A1 of the relevant sheet and the text displayed is the sheetname. To the right of each hyperlink I add any explanatory text to document my workbook.

I don't think I should post the code here as this isn't the VBA forum forum707 (and you haven't asked for a VBA solution).

If you explore the options .. you could use VBA to create an index sheet to all the named ranges in your workbook, or all named ranges that start with "Bookmark". Mind you the first of those, if you are not going to add any documentation is no better than using the name box (located at the left end of the formula bar)

Gavin

 

[SHAWTY721]

Eventually I will need a VBA solution is it possible for you to send me the link of that specific forum so I can take a look.

Thanks!

 

[SkipVought]

"...is it possible for you to send me the link of that specific forum ..."

Gavin DID post the link.

Skip,
[sub]
Just traded in my old subtlety...
for a brand NUANCE![/sub]