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
DTHIS
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" wrote in message
oups.com...
Sheet protection does not protect tab names. How can I protect tab
names?