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

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,216
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,089,992
Messages
5,411,712
Members
403,391
Latest member
electropro

This Week's Hot Topics

Top