[Mark F.]

Does anyone know of a way to pass the password to
unprotect
a worksheet in a macro as well as re-protect the
worksheet by passing a password?

Thank you for your help.

[Tom Ogilvy]

ActiveSheet.Unprotect Password:="ABCD"

ActiveSheet.Protect Password:="ABCD"

Regards,
Tom Ogilvy


"Mark F." wrote in message
...
Does anyone know of a way to pass the password to
unprotect
a worksheet in a macro as well as re-protect the
worksheet by passing a password?

Thank you for your help.