protection de-activating tab-naming code
 

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

protection de-activating tab-naming code
 

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

protection de-activating tab-naming code
 

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

"SYBS" wrote:

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