Worksheet Protection

[Adria]

I am looking for a way to prevent users from renaming
sheets, but they need the capability to add and copy
sheets.

Thanks for your help.

Adria

 

[Tom Ogilvy]

There isn't a protection scheme that supports that. Perhaps you want to use
the codename of the sheet rather than the name/tab name.

 

[Adria]

Hi Tom. The problem is that the sheet names are created
from a drop down created using data validation that
references a list on the same sheet.

If the user renames the sheet themselves, it breaks this
VB5 program that my boss wrote - I can't edit the program.
The user needs to be able to copy the sheets in the
workbook to copy the template sheet - but for some reason
it has to be named programatically. If they do it manually
the VB program craps out.

Thanks for your help. Please respond if you think of
anything.

Adria Bynum

 

[Tom Ogilvy]

Put in code that remembers the names as they should be. Use the workbook
level selectionchange event to check the sheetnames and replace them if they
don't match.