SEQUENTIAL NUMBERING OF WORKBOOKS

  • Thread starter Thread starter des-sa
  • Start date Start date
D

des-sa

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can an Excel workbook number sheet pages sequentially? 7
How do I set up worksheet tabs to change based on a workbook cell 1
Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
Sequential Numbering in a Template 2
How do I sequentially number every third page of my workbook? 1
Excel workbooks 1
copy cell from one workbook to another 5
Limiting Number of Times a Workbook can be Opened 1

Back
Top