Hello
I have an excel file with multiple worksheets.
I need to hide many sheets in this file. However, only I should be able
to "unhide" the "hidden" sheet.
I did the following:
Visual Basic Editor
Double Click on the correct Project in the Explorer window
Click on the required Sheet name
Then look at the Window called Properties and you will see a property
called visible
Change the value to Very Hidden
Then Right Click on the Main Project againgo to Project Properties and
password protect the project
The above works, however, I am unable to find the Sheet to "unhide"
again when I go to Format -- Sheet -- Unhide.
What am I doing wrong? Is there any other way to simply password protect
the feature of "hiding" a work sheet?
Any help would be appreciated.
--
Thanks
Ashish Pradhan
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
