If you are changing anything on the worksheet and the worksheet is protected
then you will get an error. You need to Unprotect the worksheet, run your
code, then Protect it again.

Sub Protect90()

Sheets("Sheet1").Unprotect "password"

'your code here

Sheets("Sheet1").Protect "password"

End Sub

Ryan

"Samantha" wrote:

Is there any way to make macros work once my document is protected? If so how?