SEQUENTIAL NUMBERING OF WORKBOOKS
 

when the question of how to get a template to number each new workbook that's
opened, regular reference to the website:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html is made, but i copied
the text, pasted it in my workbook's visual basic editor (opened by right
clicking the sheet tab view code) and nothing happenens. I did change what
i shink i should (cell references, workbook name) and nothing happens.
Please, Please can someone help me.
Thanks

SEQUENTIAL NUMBERING OF WORKBOOKS
 

To start with.....

John has code for different types of storage and retrieval of the number.

Which did you copy?

Assuming the first set which stores the number in the Registry...........

the code is Workbook_Open code and does not go into a worksheet module.

Right-click on the Excel Icon left of "File" and "View Code".

The code will be pasted into that module.


Gord Dibben MS Excel MVP

On Fri, 9 May 2008 00:09:00 -0700, des-sa
wrote:

when the question of how to get a template to number each new workbook that's
opened, regular reference to the website:
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html is made, but i copied
the text, pasted it in my workbook's visual basic editor (opened by right
clicking the sheet tab view code) and nothing happenens. I did change what
i shink i should (cell references, workbook name) and nothing happens.
Please, Please can someone help me.
Thanks