I think (as I am just busy going through the same thing), the best way seems
to be preceed the macro with ActiveSheet.Unprotect (password if one) and end
the macro with ActiveSheet.Protect (password if one)

This does enable the macros to work, but I have had a few problems making it
work consistently with up to 60 macros on a page !! Hope youre luckier.

Sybs


"Stilla" wrote:

I got help on a Macro for automatically naming tabs from a cell on a
worksheet. Works great. BUT, protecting a workbook completely deactivates
it.

Any ideas?

Thanks in advance.

Stilla