Y
Yabi
Sheet protection does not protect tab names. How can I protect tab
names?
names?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
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
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
Y
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.
G
Gord Dibben
Protect the workbook under Tools>Protection.
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP