 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008SEQUENTIAL 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 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 >when the question of how to get a template to number each new workbook that's >opened, regular reference to the website: [quoted text clipped - 4 lines] >Please, Please can someone help me. >Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.