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

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?

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

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

Lee wrote:
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?