Macro to go to a hidden worksheet. Good/Bad idea?

Hi,

I have an excel document displaying graphs that i would like to link to from a menu page (via a number of buttons). The problem is that i have about 12 of these graph sheets (along with 8 other sheets) and i'd rather not have them cluttering up the worksheet tabs list at the bottom of the screen.

Does anyone have any suggestions about how to handle this? Is a macro to open a hidden sheet and then close it once it is navigated away from a reasonable option? Or does Excel protocol suggest that they should remain visible, despite their cluttering..

Any advice would be appreciated....

Decluttering is a good thing. You have to make the sheet visible before you select it.

I've got a button on the menu sheet that runs a macro to unhide the 'chart1 sheet and open it. This works fine...

Please Login or Register  to view this content.

Ive got a button on this now unhidden sheet (chart1) that i want to run a macro on in order to go back to the menu and rehide the chart1 sheet. Ive tried various macros that seem to look like they should work, but dont. Can anyone help?

Please change the QUOTE tags to CODE tags.

Look in Help for the Visible property as it applies to sheets, and the XlSheetVisibility enumerations.

this is the macro i have to hide the sheet once the button is clicked. It goes back to the previous sheet, but doesn't hide the sheet...

Please Login or Register  to view this content.

Edit : Hi shg, ive changed the text to code, apologies.

Im a bit dim when it comes to macros.

In the Sheet module:

Please Login or Register  to view this content.