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!!
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
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:
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,101
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top