Thread: Button to copy sheet, rename sheet sequencially.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
foxgguy2005[_3_] foxgguy2005[_3_] is offline
external usenet poster
  
Posts: 1
Default Button to copy sheet, rename sheet sequencially.

I have a Setup sheet, which has a button to creat a new sheet, which
actually copies a tamplet. When i click this button it calls the new
tab "Tamplet (2)"
Is there a sub i can put in the copy routine to auto-rename the tabs
sequencially?
Note number of tabs is based upon how many times the user clicks the
new page button.

Thanks!
~Josh


--
foxgguy2005
------------------------------------------------------------------------
foxgguy2005's Profile: http://www.excelforum.com/member.php...o&userid=23663
View this thread: http://www.excelforum.com/showthread...hreadid=378885

Reply With QuoteReply With Quote