Nope there is no way to stop the user from changing the sheet tab names. You
can either train all of your users to never change the tab names or you can
write code that does not refer to the tab name (this is my prefered method).
Instead of refering to the sheet
Sheets("Sheet1").Select
change it to
Sheet1.Select

Note that you can change the code name of the sheet in the properties window
to something more appropriate than Sheet1 like shtMySheet by changing the
value beside (Name).
--
HTH...

Jim Thomlinson


"helmekki" wrote:


Hi there

Is there a code to protect the name of sheets ?

i donot want to let users change the name of the worksheets


--
helmekki


------------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...fo&userid=6939
View this thread: http://www.excelforum.com/showthread...hreadid=384357