How to hide sheets conditionally based on cell value
I'm looking for code that will hide one or more worksheets based on a cell value in Sheet1. For example if cell A2 (in Sheet1) = 2, then hide Sheet5 and Sheet6; again if A2 = 3, then hide Sheet6.
I'm a newbie and have been trying for the code for last few days but failed. So I'm looking for help from experts here.
Thanks in advance.
Last edited by masud_jahan; 05-25-2016 at 11:21 AM.
This matches your description as an example, but note that you didn't say when you want to unhide sheets. This code must be put in the code module for Sheet1.
Please Login or Register to view this content.
Hi,
Maybe
Where Sheet1 & Sheet2 are the VBA code namesPlease Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks Jeff. It can hide the sheets successfully but the problem now to unhide the sheets as you pointed out. I need the sheets to unhide if else (if A2 not equal to 2 or 3)
EXCEL's BUILT IN FEATURE
Do you know that excel has a built in feature for this ? On the View tab there is a function called "Custom Views". With custom views you set up your sheets they way you want to view them ... or hide them ... and give that view a name. Then whenever you want that view to be used you just select the name of the view from the drop down list.
If you are using it a lot the drop down list can be moved to your home tab.
How are you going to change A2 if the sheet is hidden? Is A2 a formula driven by other cells?
Thanks Richard for your reply. A2 is a cell in Sheet1 which will be changed manually. I need to hide/unhide Sheet5 & Sheet6 only not Sheet1.
Last edited by masud_jahan; 05-25-2016 at 12:00 PM.
Try this to unhide sheets as needed:
Please Login or Register to view this content.
Thanks a lot Jeff
The unhide issue is solved now.
I modified your code little like below as I modified my condition as well and its working great:Originally Posted by 6StringJazzer
Please Login or Register to view this content.
Last edited by masud_jahan; 05-28-2016 at 12:26 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks