Excel VBA, Hide/Unhide worksheets, Password protected file...

EverClear

New Member
Joined
Oct 23, 2012
Messages
32
Hi there,

I have an Excel file with a macro to unhide certain worksheets when the user clicks a button. I also have a "control table" worksheet hidden in the file that I do NOT want users to access. My dilemma is -- if I password-protect the structure of the workbook to prevent users from unhiding the control table, then the unhide macro will not work. However, if I do not protect the workbook, then the users can unhide the control worksheet and alter it (one user has already done so :mad:!!).

I really do NOT want users to unhide the control worksheet, let alone to edit it. But I do not want to lose the functionality of the unhide macro. I am uncertain how to proceed. Any suggestions would be appreciated.

Thank you!!
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,214
Have the macro that Unhides sheets also toggle the workbook protection off\on

Code:
    ThisWorkbook.Unprotect Password:="Secret"
        [COLOR=green]'Unhide sheets here[/COLOR]
    ThisWorkbook.Protect Password:="Secret", Structure:=True, Windows:=[COLOR=darkblue]False[/COLOR]
You may want to password protect the code module too so that the users cannot see the workbook password in the code.
 
Last edited:

iggydarsa

Well-known Member
Joined
Jun 28, 2005
Messages
1,647
try this, in VBE (Alt+F11)
select the sheet named "control table"
on the visible property make it "xlveryhidden"
Password protect your VBE (Tools > VBA Project Properties > Protection tab)
 

Forum statistics

Threads
1,089,668
Messages
5,409,630
Members
403,273
Latest member
Yandos

This Week's Hot Topics

Top