Numbering Worksheets

[jheison]

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?

 

[Mike H]

Hi,

This must be a contender for the most often asked question and most
respondents direct people here

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Mike