View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
adam
 
Posts: n/a
Default Adding worksheet tab names to the first worksheet

Hello, I am trying to figure how to automatically add a new worksheet tab
name to the first worksheet. For example, when I create a new worksheet, I
will change the tab name to something like 2500 and so on. I want the name
of that tab, when created, automatically added to the for worksheet which is
like a log of all the 2500 names. I also want, next a specific function to
be done automatically next to the name of the sheet, based on a number on
that new sheet.

thanks
adam