Unprotecting worksheet in a macro.

  • Thread starter Thread starter Mark F.
  • Start date Start date
M

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.
 
ActiveSheet.Unprotect Password:="ABCD"

ActiveSheet.Protect Password:="ABCD"

Regards,
Tom Ogilvy
 
Back
Top