Macros Do Not Work on Password Protected Sheet

[bsteeves]

I have a sheet which is password protected, when I try to run my macros I get an error message "cannot run the macro. The macro may not be available in this workbook or all macros may be disabled.

I went into the settings and all macros are enabled.

 

[Smitty]

To run code on a protected sheet you can add:

ActiveSheet.Unprotect "PasswordHere"

At the beginning, and reprotect it at the end.

Although if macros were disabled, you'll want to enable them and reopen the workbook.

HTH,