I am wondering if it is possible to have a protect macro that has a hardcoded
password so that a user can run the macro and it will protect with the same
macro every time, but the have an unprotect macro that makes people type the
password in. I currently have an unprotect macro, but it when the protected
sheet has a password has a password on, it errors out.

Any suggestions?

Currently I have this
To Protect:
ActiveSheet.Protect Password:="123", DrawingObjects:=True, Contents:=True,
Scenarios:=True

To Unprotect:
ActiveSheet.Unprotect DrawingObjects:=True, Contents:=True, Scenarios:=True

When you run the protect macro and then the unprotect macro it causes an
object or application defined error.

Thanks.