Automatically make buttons for sheets

[elmacay]

Hi all,

I have about a 100 worksheets in one file. I have a list of all of them in "sheet1". Next to the names of the 100 sheets, I would like to make a button that goes to the corresponding sheet. Is it possible to make a loop so that I get 100 of the same buttons with a macro attached that direct the button to the sheet? Do I have to make a sample button first so that it can be copied?

Would be great, would save me a lot of time!

Cheers, Elmacay

 

[GlennUK]

Have you considered using the HYPERLINK worksheet function to create links to the sheets that can be navigated, as you already have the sheet names there?

For example:

Excel Workbook
	A	B
1	Sheet name
2	Data	Go to sheet ...
3	Items	Go to sheet ...
4	Summary	Go to sheet ...
5	Another Summary	Go to sheet ...
Sheet8

 

[elmacay]

Of course... Didn't think of that. Works like a charm. Thanks!

 

[GlennUK]

That's great.