Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
password protect multiple worksheets with macro and exceptions
I have a 50+ sheet workbook that I need to password protect with a macro.
Unfortunately, I need to have exceptions for hyperlinks along with autosort and autofilter among others. I have found answers for autofilter on this site but no luck with the others. I am using the following code to protect: Private Sub CommandButton1_Click() Dim wSheet As Worksheet For Each wSheet In Worksheets If wSheet.ProtectContents = True Then wSheet.UnProtect Password:=TextBox1.Text Else wSheet.Protect Password:=TextBox1.Text End If Next wSheet Unload Me End Sub Any help would be greatly appreciated. Thank you in Advance, Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Multiple Worksheets from view before password | Excel Discussion (Misc queries) | |||
password protect multiple worksheets in excel | Excel Discussion (Misc queries) | |||
Can I password protect worksheets? | Excel Worksheet Functions | |||
Password Protect Worksheets | Excel Worksheet Functions | |||
Macro to Open and Compile Multiple Worksheets that are password protected | Excel Programming |