Results 1 to 7 of 7

Use checkbox to show/hide sheets?

Threaded View

  1. #1
    Registered User
    Join Date
    03-25-2009
    Location
    Sweden
    MS-Off Ver
    Excel 2003
    Posts
    49

    Use checkbox to show/hide sheets?

    Hey

    Im having a small problem that im trying to solve in some way. I only have some knownledge in basic macros and not in VBA, and since i cant figure out a way to solve my problem.

    Is it possible to do this.

    I have a workbook (i attach a testfile). Right now i have 4 sheets in it. The "Main Sheet" is called "Pre"

    Here i have 3 checkboxes.

    I also have 3 "hidden" sheets called "sheet1", "sheet2" and "sheet3".

    What im trying to do is when i "mark" the checkbox called "sheet1" then i want the hidden "sheet1" to show up. And same goes with all the sheets.

    So basicly when i click "sheet1" checkbox that sheet will get unhidden.
    Attached Files Attached Files
    Last edited by Zheno; 11-03-2010 at 02:23 PM.

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