View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rhani111[_8_] rhani111[_8_] is offline
external usenet poster
 
Posts: 1
Default Automatic naming Worksheet tabs


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