+ Reply to Thread
Results 1 to 11 of 11

Need Option Button To Hide Or Unhide Worksheets

Hybrid View

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Thumbs up Need Option Button To Hide Or Unhide Worksheets

    Dear Respected

    i need a code for Option Button to Hide Or Unhide Worksheets.........

    e.g if i check that worksheet hide, if i unchecked then unhide worksheet

    thanx :
    Haroon2015
    Last edited by HaroonSid; 03-13-2014 at 12:04 AM. Reason: solved

  2. #2
    Valued Forum Contributor adyteo's Avatar
    Join Date
    01-10-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2010
    Posts
    540

    Re: Need Option Button To Hide Or Unhide Worksheets

    see the attached file
    Attachment 303748
    Click on the star if you think I helped you

  3. #3
    Valued Forum Contributor
    Join Date
    01-19-2010
    Location
    Melbourne Australia
    MS-Off Ver
    latest is Excel 2016. have older versions
    Posts
    624

    Re: Need Option Button To Hide Or Unhide Worksheets

    good solution to the post, well done, my bet is that it isn't what the OP was actually thinking their problem actually is, stand by for follow up.. "but how.." questions.

  4. #4
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: Need Option Button To Hide Or Unhide Worksheets

    Thanx for rep

    but i m not satisfied with this one
    Last edited by HaroonSid; 03-12-2014 at 05:45 AM.

  5. #5
    Valued Forum Contributor
    Join Date
    01-19-2010
    Location
    Melbourne Australia
    MS-Off Ver
    latest is Excel 2016. have older versions
    Posts
    624

    Re: Need Option Button To Hide Or Unhide Worksheets

    sorry, I hit the wrong post, rep was actually for @adyteo solution

    Cheers

    Jmac1947

    1. Please consider clicking on the * Add Reputation if you think this post has helped you
    2. Mark your thread as SOLVED when question is resolved

  6. #6
    Valued Forum Contributor adyteo's Avatar
    Join Date
    01-10-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2010
    Posts
    540

    Re: Need Option Button To Hide Or Unhide Worksheets

    haroon, if your problem is solved, do not forget to mark the thread as [SOLVED]

  7. #7
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: Need Option Button To Hide Or Unhide Worksheets

    Sorry adyteo

    my problem is not solved

    because of my mistake

    Using checkbox hide or unhide the sheet
    Last edited by HaroonSid; 03-12-2014 at 08:44 AM.

  8. #8
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Post Re: Need Option Button To Hide Or Unhide Worksheets

    Sorry adyteo

    my problem is not solved

    because of my mistake

    Using checkbox hide or unhide the sheet

    I WANT LIKE THIS ONE
    Attached Files Attached Files

  9. #9
    Valued Forum Contributor adyteo's Avatar
    Join Date
    01-10-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2010
    Posts
    540

    Re: Need Option Button To Hide Or Unhide Worksheets

    can you please explain what is not working?

  10. #10
    Valued Forum Contributor adyteo's Avatar
    Join Date
    01-10-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2010
    Posts
    540

    Re: Need Option Button To Hide Or Unhide Worksheets

    if the sheets are checked they will be made visible, if the sheets are unchecked, they will be hidden.

    Attachment 303823

  11. #11
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: Need Option Button To Hide Or Unhide Worksheets

    Thanx Alot adyteo

    i need this alot........................

    it working very well

+ 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. Using command button to hide/unhide worksheets
    By Sly1980 in forum Excel General
    Replies: 1
    Last Post: 05-31-2012, 03:44 PM
  2. Protect the Hide/Unhide option
    By Bestycame in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2011, 01:48 PM
  3. Replies: 2
    Last Post: 04-18-2011, 01:56 AM
  4. Hide row if cell is a certain value, with unhide toggle option
    By stir-crazy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-16-2008, 09:16 PM
  5. Hide/Unhide Option - Need to consider all options!
    By Turquoise_dax in forum Excel General
    Replies: 3
    Last Post: 06-15-2006, 04:17 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