+ Reply to Thread
Results 1 to 7 of 7

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

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    Posts
    285

    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....
    Last edited by Barking_Mad; 03-10-2010 at 11:29 AM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

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

    Decluttering is a good thing. You have to make the sheet visible before you select it.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    Posts
    285

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

    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?
    Last edited by Barking_Mad; 02-23-2010 at 05:07 PM.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

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

    Please change the QUOTE tags to CODE tags.

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

  5. #5
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    Posts
    285

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

    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.
    Last edited by Barking_Mad; 02-23-2010 at 05:15 PM.

  6. #6
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    Posts
    285

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

    can anyone help with this? When I set the macro to leave and hide the sheet, it just leaves it, but fails to hide it...

  7. #7
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,658

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

    In the Sheet module:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1