| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Template Constant Update
Hello
I have a workbook which has sequential numbering as per the code below: Private Sub workbook_Open() worksheets("FORM").Range("K2") = worksheets("FORM").Range("K2") + 1 End Sub My question is if I use this workbook as a template with data tracking, how can I keep the sequential numbering to go on once I have saved it as xlt. Thanks in advance for a reply/solution AJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seting a Constant (via code) when creating a new file based on a template | Excel Programming | |||
| Setting a Constant when creating a new file from a template? | Excel Programming | |||
| How do you update a public constant | Excel Programming | |||
| Template Update | Excel Programming | |||
| A constant update | Excel Programming | |||
Threaded Mode
