Help; When protecting the Workbook, tab Macros won't work

[Guest]

How can I ensure that my tab Macro work when I have protected the Workbook.

I need to protect the workbook, to prevent copying of worksheets and moving
of tabs. however when the workbook and sheets are protected the macros fail
to work, resulting in an error message.

How do I overcome this?

 

[Rowan]

In your macro, unprotect your workbook, do whatever you want to do, then
protect the workbook again eg:

ActiveWorkbook.Unprotect Password:="mypassword"
'code
ActiveWorkbook.Protect Password:="mypassword"

Hope this helps
Rowan