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?