Macro to Unprotect sheet!?

try this:

Please Login or Register  to view this content.

If you want to assign this to a button, uncomment the Private Sub line and comment out (or remove) the Sub line.

HTH

Bruce

Originally Posted by Neo1

Any help to create a macro to unprotect worksheet but before it does to pop up the dialogue box asking user to enter password to unprotect worksheet?

I need help pleasee
Thanks a lot
From John

Hi Neo1,

It sounds like you want the sheet to automatically unprotect with a password.
If this is so, Just add to Bruce's code for the password.

Put this in the Module for the sheet in question.
Right Click on the worksheet tab and select "View Code".
Paste the folowing code there. Don't forget to replace your password where it says "your password goes here"

Private Sub Worksheet_Activate()
ActiveSheet.Unprotect Password:=your password goes here
End Sub

Same thing without a password:

Private Sub Worksheet_Activate()
ActiveSheet.Unprotect
End Sub