Indy has attended:
Project Intro Intermediate course
Excel Advanced course
Excel Intermediate course
Macro to print certain sections only
Hey,
I need to produce a macro to print out certain sections of a document which could vary in size depending on who fills them in, i.e. section 2 could be 1 page from me but 4 pages from you.
Any suggestions?
Cheers,
Indy
RE: Macro to print certain sections only
Hi Indy
Thanks for your question.
You can print certain sections from your document by entering 's' followed by the section number into the Pages box in the Print dialogue box (e.g. to print section 2, type s2 into the Pages box).
Test this first, then you can create the macro by:
1. Go to Tools - Macro - Record new macro and give the macro a name. The name you assign cannot have spaces in it.
2. Carry out the steps required to print the section of the document you want to print (i.e. go to File - Print etc).
3. Click the Stop recording button on the macro toolbar.
4. If you wish, add the macro to a toolbar by going to Tools - Customise - Commands. Choose Macros from the Categories list - the name of your macro should appear in the box on the right. You can drag and drop your macro onto the toolbar.
Hope this helps.
Amanda