Protect the workbook under ToolsProtection.


Gord Dibben MS Excel MVP

On 16 Apr 2007 01:30:48 -0700, "Yabi" wrote:

On Apr 16, 9:50 am, "Nick Hodge"
wrote:
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

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

"Yabi" wrote in message

oups.com...





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

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.