(AidanH replying from home!) - I would GUESS that the sheet is already
protected with a password different from the one you expect (perhaps CAPS
instead of caps - these are different to Excel you see)

"Modell" wrote in message
...
Thanks Aidan. It works, but for some reason when I try to unprotect the
worksheet from Excel and put in the password it's telling me that my
password
is incorrect. When I run the macro which protects and unprotects the
worksheet with the password it works fine. Any thoughts?

"AidanH" wrote:

should work fine - see

ActiveSheet.Protect Password = "FRED"
ActiveSheet.Unprotect Password = "FRED"


which (rather pointlessly) protects and unprotects a sheet without
doing anything else