Macros do not work when worksheet is protected

[a_williams]

Hi

Can someone please help me? I have a workbook that will be used by several people. I need the cells containing formulas to be locked, but when I protect the worksheet, the macros that i have in the workbook can't run - it comes up with an error message box.

Please help! Thank you!

[Winon]

At the beginning of your code where Protected cells are referred to enter a Line to UnProtect that Sheet.
Some thing like:

Please Login or Register  to view this content.

And at the end of that Code Protect the Sheet again, something like:

Please Login or Register  to view this content.

Where "Sheet Name" = the actual name of the Sheet and "Password" = the actual password for that Sheet.

Hope that helps.

[a_williams]

Brilliant, thank you!!

[Winon]

You are wellcome,

Please remember to mark your Thread as Solved.