I wish to create a Macro for the Print Set Up Page. Can anyone help?
I wish the Macro to take the user as far as the Print Set Up Page, but not automatically select the printer and print. So the user can still select the Printer, No. of copies, Page Range etc.
Last edited by Lewis Midson; 03-10-2010 at 06:30 AM. Reason: Unclear
What do you want to do with the print setup?
The classic way to do this is to record a macro to do what you want to do, then look at the code and clean up as necessary.
I'm sure someone here could provide the actual code if you describe what settings you want to apply.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks