+ Reply to Thread
Results 1 to 3 of 3

using different checkboxes in the same worksheet to unhide/hide worksheets

  1. #1
    Registered User
    Join Date
    09-20-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003
    Posts
    12

    using different checkboxes in the same worksheet to unhide/hide worksheets

    Hello,

    I'm new at VBA and I'm trying to have on one worksheet ActiveX checkboxes to hide/unhide several worksheets.

    Below is the idea. If I check the checkbox 1, I have 3 or 4 worksheets opening, If I check the checkbox2, I will have other ones.

    Please Login or Register  to view this content.
    Would you have a solution to make it work because with this code, only the checkbox2 works now?

    Thanks!

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: using different checkboxes in the same worksheet to unhide/hide worksheets

    Not sure what you are trying to achieve as the Checkboxes are not linked.

    Your code works.
    Attached Files Attached Files
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    09-20-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: using different checkboxes in the same worksheet to unhide/hide worksheets

    Hello,

    Thanks for the reply. I checked your file and figured out I made a mistake. I was calling "checkbox1" instead of "checkbox".

    It works now!

    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] VAB/Macro to unhide, unprotect, copy to other worksheets, protect & hide worksheets again
    By Roma1r in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-08-2018, 08:26 AM
  2. [SOLVED] Help Needed with Checkboxes to Hide or Unhide Rows
    By dgibney in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-25-2014, 11:39 AM
  3. [SOLVED] Hide and Unhide Sheets using Checkboxes
    By DallasArosco in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2014, 11:28 AM
  4. [SOLVED] Hide/unhide rows with checkboxes
    By mixer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2014, 03:58 PM
  5. need macro to hide/unhide columns through multiple checkboxes
    By trier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2013, 04:00 PM
  6. Using multiple checkboxes as an index page to hide/unhide worksheets
    By Damien_Lee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2013, 07:24 AM
  7. Hide/Unhide Multiple Checkboxes
    By LampCommandr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2011, 09:35 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