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 " wrote in message
...
Simple problem I think.

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

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


---
Message posted from http://www.ExcelForum.com/