protection for tab names

[Yabi]

Sheet protection does not protect tab names. How can I protect tab
names?

 

[Nick Hodge]

Yabi

Is there a reason for this. If it is to keep code running, there is a
CodeName property that cannot be changed in the UI. You can refer to this
and it is totally independent of the worksheet tab name

Sheet1.Range("A1").Value

for example.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

 

[Yabi]

Yabi

Is there a reason for this. If it is to keep code running, there is a
CodeName property that cannot be changed in the UI. You can refer to this
and it is totally independent of the worksheet tab name

Sheet1.Range("A1").Value

for example.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web:www.nickhodge.co.uk
blog:www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007www.officeusergroup.co.uk

I have links in sheet 1 to 15 sheets from sheet 2 to 16. if I change
sheets name, then the link will not work. I want to protect sheets
from changing.

 

[Gord Dibben]

Protect the workbook under Tools>Protection.


Gord Dibben MS Excel MVP