Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sequential numbering | Excel Discussion (Misc queries) | |||
PO with sequential numbering with start / end numbering | Excel Discussion (Misc queries) | |||
Sequential Numbering | Excel Discussion (Misc queries) | |||
Sequential numbering | Excel Worksheet Functions | |||
Sequential Numbering. | New Users to Excel |