View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default Sheet NameTab Protection

Thanks for the replies. I will look into the CODE names

--
Cheers
Nigel



"Fredrik Wahlgren" wrote in message
...

"Nigel" wrote in message
...
Hi All
Can anyone advise how to protect the sheet name tab?
I have protected the sheet but the Tab can still be
edited. I want to stop users from changing names as these
are used in VBA for navigation.

Cheers
Nigel


You have to protect the workbook to achieve this.

/Fredrik