A macro in my workbook produces anywhere up to 20 different sheets, and I would like to find a better way of navigating those sheets than the tabs at the bottom, as you can only see certain ones.
I thought I might set up an additional worksheet with buttons that take you to the specified page, but I've had difficulty. I can produce a list in Column A of all the names of the sheets, but I'm not sure how to create buttons with those names, and furthermore have each button take you directly to that page. I'm thinking it would work by using the Button's name to find the sheet, but i don't know how to access the button's name.
Alternatively, can i make a worksheet where just clicking on a cell takes you to the sheet with that cell's name? Any suggestions?
I thought I might set up an additional worksheet with buttons that take you to the specified page, but I've had difficulty. I can produce a list in Column A of all the names of the sheets, but I'm not sure how to create buttons with those names, and furthermore have each button take you directly to that page. I'm thinking it would work by using the Button's name to find the sheet, but i don't know how to access the button's name.
Alternatively, can i make a worksheet where just clicking on a cell takes you to the sheet with that cell's name? Any suggestions?