protection de-activating tab-naming code

S

Stilla

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
 
S

SYBS

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
 
S

SYBS

Forgot to mention (cos I just found out), mine worked fine when I did the
activate thing but I had to then go back and put the password in brackets and
quotes. If yours still isn't working try that. Hope it helps.

Sybs
 
Top