Worksheet Protection

  • Thread starter Thread starter Adria
  • Start date Start date
A

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
 
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.
 
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
 
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.
 
Back
Top