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.
Microsoft ExcelVisual Basic Classic
Last Comment
grnow
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
ASKER
the xlSheetVeryHidden feature is working well for the user.
ASKER
suggestions meet user's expectations
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