+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    03-09-2010
    Location
    Luton, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Print Set Up Macro

    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

  2. #2
    Forum Guru 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Vienna, VA, USA
    MS-Off Ver
    Excel 2003, 2007
    Posts
    2,242

    Re: Print Set Up Macro

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0