protect sheet macro - can't have it enter password

[inaz]

Simple problem I think.

I record a macro to protect a sheet and enter the password durin
recording. However, when I play the macro, the sheet is protected bu
it is not password protected. It can be unprotected without entering
password.

Why isn't the password part of the macro? And how do I get it in ther
????

 

[mudraker]

Replace a line in your code that would be similar to this


To Protect an active sheet

ActiveSheet.Protect PASSWORD:="Password Phrase Here",
DrawingObjects:=True, Contents:=True, Scenarios:=True

To Unprotect an active sheet

ActiveSheet.Unprotect PASSWORD:="Password Phrase Here"

 

[John Wilson]

inaz,

Why it doesn't record the password, I couldn't tell ya'
Go into the VBA editor and add the following to the recorded line:
, password:="yourpassword"

The whole line should read something like this:
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True,
password:="yourpassword"

John

 

[inaz]

Works great - Thanks alot :

 

[John Wilson]

inaz,

No problem.
Happy to have been a help.

John