password protect macro

[Guest]

How do I run a macro that will unprotect the sheet by entering the password,
run the macro, and then password protect the sheet again by re-entering the
password after the macro runs so users are not able to tamper with the data
in the spreadsheet?

I get an error when I try this with an actual password, but it works if I
protect the sheet without a password.

Thanks for your help.

 

[AidanH]

should work fine - see

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


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

 

[Guest]

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?

 

[Heather Heritage]

(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)