Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 05-30-2013, 02:03 PM
macropod's Avatar
macropod macropod is offline need help with numbering NCR forms Windows 7 32bit need help with numbering NCR forms Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

To install the macro:
• open your workbook and press Alt-F11. This opens the VBA editor.
• to the left you'll see a panel with your workbook name. Click on that.
• choose Insert|Module.
• copy and paste the macro I posted into that module.
• press Alt-F11 again. This closes the VBA editor.
The macro is now installed. Save your workbook, making sure you save it as a macro-enabled workbook (xlsm format). From now on, to use the macro:
• press Alt-F8 and choose PrintNCRSeries>OK.
• input the form range (eg 3601-3651), then press OK.
The macro defaults to one more than whatever number is already in F12, ending 10 forms further on. So, if you save the workbook after printing, or you simply run the macro again before closing the workbook, the next sequence will offered the next time you start the workbook. If you'd prefer a different default sequence length, simply change the '10' in the macro.

If your system's macro security is set too high to allow macros to run, click on Developer>Macro Security and set it to 'Disable all macros with notification'. With this setting, you'll be asked whether to enable the macro each time you open the workbook, without the risk of 'macro viruses' in workbooks others might send you being able to run without your say-so.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
ncr forms, numbering, numbering forms



Similar Threads
Thread Thread Starter Forum Replies Last Post
forms mrmagoo Word 2 06-28-2012 01:25 PM
Forms textboom Word VBA 0 02-23-2011 07:51 AM
Document unique numbering / forms JamesF Word 0 11-22-2010 03:52 AM
Forms help benji842 Word 0 06-24-2010 06:04 AM
Forms oo7juk Word 0 10-09-2009 01:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft