Hello All,
I work on my application in Excel and I would like to implement a macro which will hide or unhide sheets based on the cell value.
this cell value can have only two values (1 or 2).
i was looking for information over internet, found few posts but it simply saying still it does not work...
i would like to have this marco to run continously background.
Please Login or Register to view this content.
can you support me, please?
best regards
Sebastian
What are your conditions?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
S25 check if another cell has a value or it is emplty.
You need to give more details. Its not clear what you are trying to say.
cell S25 has a If function, checks if B1 has a text or not. if it has it shows 1 and then I would like to start macro unhiding some sheets. when s25 returns 2 I would like to hide some sheets.
B1 cell base on validation data and Vlookup function.
i hope now is clear.
Please Login or Register to view this content.
JeffCasey,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
Dear All,
thx for the support.
after changes based on your comments it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks