Microsoft Office Forums - View Single Post - [Solved] need help with numbering NCR forms

macropod · 05-30-2013, 02:03 PM

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.