protection de-activating tab-naming code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference the same cell based on tab name 1
Tabbing on a Protected worksheet 3
Excel Move or Copy Stopped Working? 0
Does protecting a workbook shut off VBA code? 1
How do I set up worksheet tabs to change based on a workbook cell 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Tabbed cells 1
How to get range names to Apply across multiple tabs 1

Back
Top