Results 1 to 7 of 7

VBA to UnHide/Hide Sheets

Threaded View

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    Fairbury NE
    MS-Off Ver
    Excel 2007
    Posts
    70

    VBA to UnHide/Hide Sheets

    I have a workbook with about 20 worksheets in it.
    6 are visible
    3 are hidden
    the remaining are very hidden

    I'm creating a "welcome" page to the workbook with instructions on how to update data. The data between the 20 sheets consists of pivot tables, charts and summary data. The Visible sheets are data for management's review (all protected). The 3 hidden sheets are pivot tables that the user needs to pull data from and the very hidden sheets are not to be seen by anyone.

    In my "welcome" page, I added the instructions of how to update data, but wanted an area where I could assign a checkbox or button to click on for the user to unhide my 3 hidden sheets (say Sheet1, Sheet2 and Sheet3). I do not want it to unhide my very hidden sheets. Then, when the information needed is retrieved from those sheets, I would like the user to use a checkbox or button to hide the 3 hidden sheets again. Is there a way to do this?

    I tried creating custom view but couldn't do that because of the pivot tables (the option was disabled). I'm a beginner in VBA so don't even know how to begin. Hoping someone can help.
    Last edited by maryren; 02-20-2014 at 05:01 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hide/Unhide sheets
    By mnewdick in forum Excel General
    Replies: 4
    Last Post: 07-19-2013, 10:11 AM
  2. Hide & Unhide sheets
    By Zorro9758 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-05-2013, 04:41 PM
  3. [SOLVED] hide unhide all sheets except for the active one
    By Bishonen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2012, 09:41 AM
  4. [SOLVED] Hide or unhide sheets
    By Jakes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2012, 02:09 AM
  5. Hide/Unhide Sheets
    By Runner77 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2006, 05:25 AM

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