View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jheison jheison is offline
external usenet poster
 
Posts: 2
Default Numbering Worksheets

I need to know how to number worksheets so everytime I save as and open a new
one the next number automatically comes up. For example: I want to star the
first worksheet with CBKI001 And I want that when I save it and open a new
one it reads CBKI002. I want this to happen only if I save it not if it is
opened and not saved. Is this even possible?
--
Jheison