View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default protection for tab names

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?