I have a workbook with 11 worksheets
Sheet1 and Sheet2 I want to remain open. Sheets3-11 I would like very hidden when the workbook closes. to unhide Sheets 3-11 would need password.
How can this be done through vba?
Thanks
Jim
I have a workbook with 11 worksheets
Sheet1 and Sheet2 I want to remain open. Sheets3-11 I would like very hidden when the workbook closes. to unhide Sheets 3-11 would need password.
How can this be done through vba?
Thanks
Jim
Hello Jim,
The only way a sheet that is very hidden can be accessed is through VBA. The sheet's visibility property must be changed either manually or by writing a VBA macro. The user can not unhide the sheet using the Ribbon. So why do you need to hide these sheets again when the workbook closes?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Sheets3-11 are data sheets relating to a dashboard and charts on Sheets1-2
When I open the file I want to unhide all the sheets so I can add data where needed. When it closes I send the file to other managers - they don't need to know or access the other 3-11.
I found the following at pifflelab.com that does the job very well
Hides specified sheets as very hidden; unhides with password; hides as very hidden when exit
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks