Problem: I have a file with 11 worksheets. In Sheet1 I have 10 rows. If cell A1 is "No" or "blank" I would like to hide "Sheet2", if cell A2 is "No" or "blank" I would like to hide "Sheet3" and so on. Solution?
Problem: I have a file with 11 worksheets. In Sheet1 I have 10 rows. If cell A1 is "No" or "blank" I would like to hide "Sheet2", if cell A2 is "No" or "blank" I would like to hide "Sheet3" and so on. Solution?
Use this-
Check attached.![]()
Please Login or Register to view this content.
If you type anything except "No" the sheet will be unhided.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
May be
![]()
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
How to make the macro run when cell Changes in cell A1:A10?
Now this would work automatically.
Hm... now we moved input cells from A1 and down to D4 and down and macro does not work. How to change the macro? Is it possible to use defined names instead?
Yes you can define your range name it for example "List" and try this
![]()
Please Login or Register to view this content.
Right click on Master Sheet >>view code>>put this code there-
Check attached.![]()
Please Login or Register to view this content.
YasserKhali, thanks! Your solution works excellent! How to make it run automatic?
YasserKhali, thanks! Your solution works excellent! How to make it run automatic? (when cell Changes)
YasserKhali, thanks! Your solution works excellent! How to make it run automatic? (when cell Changes - in List-area)
Hi
Just right Click sheet1 tab then view code and paste this code
![]()
Please Login or Register to view this content.
THANKS A LOT!!! Perfect.
You're welcome
Glad I can help
Thanks for the feedback and for the rep points
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks