I need to rename the sheet tabs on the worksheets. Is
there a way to lock the renamed tabs so that no one else
can accidently change them?

Thanks.

Protect the workbook - at least the structure.

--
Regards,
Tom Ogilvy


Peter wrote in message
...
I need to rename the sheet tabs on the worksheets. Is
there a way to lock the renamed tabs so that no one else
can accidently change them?

Thanks.

Peter,

As you have posted in the programming group, I assume you want stable names
for your VBA code?

If so, you could use the codename property as users cannot change this in
Excel. The codename is the name NOT in brackets in the sheet names in the
VBE explorer. Usually both names are the same, but they don't have to be. To
change the codename, click the worksheet in the VBE, and change the name
property in the properties window.

To access a worksheet through its codename, use code like

Sheet1.Range("A1")
instead of
Worksheets("Sheet1").Range("A1")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Peter" wrote in message
...
I need to rename the sheet tabs on the worksheets. Is
there a way to lock the renamed tabs so that no one else
can accidently change them?

Thanks.