Link to home
Create AccountLog in
Avatar of grnow
grnowFlag for Singapore

asked on

hide a worksheet in excell 2007/2010

think this question had been before, wnat to get a confirmation. is there any workaround that can hide a worksheet in the workbook? If people try to unhide the worksheet, there would be password prompt.
ASKER CERTIFIED SOLUTION
Avatar of Randy Downs
Randy Downs
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of grnow

ASKER

number-1, I try your method but it seems anyone can just go back to the worksheet to remove the password and unhide the worksheet again. any workaround on this?

aikimark, yes, i would require the worksheet to be unhidden again so the creator of the worksheet can edit stuff on the 'hidden' worksheet. i tried the code above but i think missed out on your mentioning of creating a macro and using routing. Can provide more info on this? thanks
You will have to password-protect the code.  It isn't very difficult to do, but you should wait until you have code that works the way you want.  Then, it is just a matter of 'packaging' the code.
You need a password if you reopen the sheet with the method above. If it's already open you don't get challenged,
What we need to know is the context of the sheet being visible.  I would expect that we would need to have code that will cause the worksheet to be hidden when the workbook is closed.
Avatar of grnow

ASKER

the xlSheetVeryHidden feature is working well for the user.
Avatar of grnow

ASKER

suggestions meet user's expectations