+ Reply to Thread
Results 1 to 8 of 8

Macro to Hide and Unhide sheet except 2

  1. #1
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 365
    Posts
    258

    Macro to Hide and Unhide sheet except 2

    Hi all :-)


    Hope, that anybody would be able to help me with following :-)

    I was using below macro to hide and unhide all sheet and to have only Home visible. What I want now is to add one more sheet to be visible "Cover Page", but my macro does not work then .

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    Not sure, what is wrong

    Thanks,
    Andy

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to Hide and Unhide sheet except 2

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 365
    Posts
    258

    Re: Macro to Hide and Unhide sheet except 2

    Nope, doesn't work Still same sheet only.

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Macro to Hide and Unhide sheet except 2

    Please Login or Register  to view this content.
    If you are happy with my response please click the * in the lower left of my post.

  5. #5
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 365
    Posts
    258

    Re: Macro to Hide and Unhide sheet except 2

    Hi,

    thanks for your reply, however doesn't work. What I need when pressing button to hide and unhide all sheets. Those 2 have as visible.

    For Home sheet my macro works, but not with the 2 of them.

  6. #6
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Macro to Hide and Unhide sheet except 2

    You probably have the sheet name wrong (e.g. extra space). Run this:

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 365
    Posts
    258

    Re: Macro to Hide and Unhide sheet except 2

    No no , al is good, not sure, where's the issue

  8. #8
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to Hide and Unhide sheet except 2

    I think this is what you want. Place Stnkynts' code in post 4 in a regular module. Then in your Workbooks Open Event.

    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)

Similar Threads

  1. [SOLVED] Listbox macro to hide/unhide rows in different sheet
    By dgibney in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2014, 02:01 PM
  2. [SOLVED] allow hide/unhide rows&columns when sheet protected (macro)
    By jw01 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-15-2013, 03:18 AM
  3. Replies: 1
    Last Post: 08-19-2011, 10:25 AM
  4. Macro to hide/unhide rows using box then duplicate through sheet
    By BEEGINA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-05-2011, 11:51 PM
  5. Macro to unhide/hide sheet(s)
    By cispus78 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2008, 03:18 PM
  6. [SOLVED] Hide/unhide sheet macro based on cell calculation
    By Greg Fisher in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2005, 05:19 PM
  7. Macro/VBA - Hide/unhide rows in sheet through YES/NO Controll
    By age in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-18-2005, 05:09 PM

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