Hey everyone,
I am using 2 sheets to balance confidential data: The workbook structure is protected I want to be able to unprotect the book, make one sheet visable and then make the sheet that was previously visible hidden, then protect the book again. Cant get my code to work though. Can anyone help?
Please Login or Register to view this content.
Last edited by Spear86; 04-28-2014 at 04:27 AM.
You will need to use an "If Then" statement to test which sheets are visible versus hidden, then change the properties to the opposite values for those worksheets.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
@Kelleytr, I should not require a if then statement as there is a command button on both pages allowing them to switch so i have code on each one.
@shg with that I am getting run-time error '438' - stating object does not support method on that.
I don't think you can have copied shg's code correctly - it works as posted.
Remember what the dormouse said
Feed your head
Thanks managed to get it to work it was the Spacing on my sheet for CEL (2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks