Worksheets have 2 names; WS.Name that appears on the sheet tab in Excel and
WS.CodeName that is only accessible from VBA.
So you can use the .CodeName to refer to sheets whilst changing their .Name,
which then becomes irrelevant as far as your code is concerned.

NickHK

"rhani111" wrote in
message ...

Hi All,

Here is a curly one....I have the automatic worksheets being renamed by
a vba code. The problem I'm having is there is a macro button to hide
and unhide these same sheets. Once the names have been changed, the
sheets won't open for THAT exact reason, the macro can no longer find
the sheet names.

Is there any way around this so I can have my cake AND eat it too????

Thanx
Sandi


--
rhani111
------------------------------------------------------------------------
rhani111's Profile:
http://www.excelforum.com/member.php...o&userid=19940
View this thread: http://www.excelforum.com/showthread...hreadid=555489