+ Reply to Thread
Results 1 to 7 of 7

Hide worksheets listed in one sheet

  1. #1
    Registered User
    Join Date
    04-03-2015
    Location
    Switzerland
    MS-Off Ver
    2013
    Posts
    18

    Hide worksheets listed in one sheet

    Hi
    I have a VBA hiding several sheets based on their names (arrays)
    To make it easier for others to select the sheets to be hidden, i would like to list all sheets in a new sheet and state for each „yes“ or „no“.
    Based on this selection, the sheets should be hidden or veryhidden.
    The list is not fixed but must be flexible for further sheets.
    Thanks for an idea.
    Regards
    Chris

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Hide worksheets listed in one sheet

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and click "manage attachments" to open the upload window.

    -




    See clip
    To add a file to a post

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,030

    Re: Hide worksheets listed in one sheet

    Maybe something like
    Please Login or Register  to view this content.
    Where you sheet names are in A2 downwards, with yes/no in col B.

  4. #4
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,482

    Re: Hide worksheets listed in one sheet

    or two macro's

    one to list all sheets. (can run it when creating the index sheet)
    one code to update visible status after changing of the fields

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-03-2015
    Location
    Switzerland
    MS-Off Ver
    2013
    Posts
    18

    Re: Hide worksheets listed in one sheet

    Thanks both
    How would the VBA code provided by Fluff13 look like if I would like to have the others veryhidden?
    Roel, the first works great. The second stops with error message and highlighting yellow the part after "no"
    Thanks

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,030

    Re: Hide worksheets listed in one sheet

    Try
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    04-03-2015
    Location
    Switzerland
    MS-Off Ver
    2013
    Posts
    18

    Re: Hide worksheets listed in one sheet

    works perfectly, thanks

+ 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] Hide Columns Not Specifically Listed
    By Tiglon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-16-2018, 11:53 AM
  2. [SOLVED] Hide worksheets depending on values in master sheet
    By toblju in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-26-2016, 07:36 AM
  3. Hide some worksheets of a protected sheet for multiple users
    By bolulusam in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2016, 04:07 AM
  4. Need to consolidate worksheets based of values listed under a name
    By talltxn33647 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 11-12-2015, 11:13 PM
  5. [SOLVED] Hide Sheet if Change Worksheets
    By Rschwar23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2014, 10:44 AM
  6. [SOLVED] Hide columns in multiple worksheets - each sheet has its own name
    By Tyso in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-29-2013, 01:53 PM
  7. Hide or unhide worksheets from cell values in sheet 1
    By glenin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-07-2011, 06:00 PM

Tags for this Thread

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