View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AJ AJ is offline
external usenet poster
 
Posts: 99
Default 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