+ Reply to Thread
Results 1 to 2 of 2

Macro to Print A4 and A3

  1. #1
    Registered User
    Join Date
    09-22-2009
    Location
    Sydney,Australia
    MS-Off Ver
    MS Office 365
    Posts
    39

    Macro to Print A4 and A3

    Hi All,

    Can someone please help me out with a macro so users can print in either A3 or A4 depending on their printer preferences.

    Sheet is password protected and will be landscape.

    Thanks,


    Douglas

  2. #2
    Registered User
    Join Date
    02-22-2016
    Location
    Harare, Zimbabwe
    MS-Off Ver
    2007 & 2010
    Posts
    71

    Re: Macro to Print A4 and A3

    There are so many Printers on the market which only prints in portrait that I think your Vba if possible may bomb out in such cases.
    Happy? Click the * to the left.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to open Print Preview & Print from Quick Access Toolbar
    By fastcar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2017, 04:58 PM
  2. Macro slows down when I print/print preview/page break a sheet
    By Grug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2015, 08:59 PM
  3. Disabled print toolbar and menu but Print Macro button cannot print also...
    By zein97 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-22-2014, 01:42 PM
  4. Print Macro errors on final print command. Run-time error '1004':
    By Steverizer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 06:41 PM
  5. [SOLVED] Pivot Table macro to set print area and print details of drill down data
    By Steve Haskins in forum Excel General
    Replies: 2
    Last Post: 12-28-2005, 01:10 PM
  6. [SOLVED] Create a print macro that would automatically select print area?
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  7. Create a print macro that would automatically select print area?
    By wastedwings in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM

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.6.0 RC 1