Setting Excel Spreadsheet to A3 printer friendly

[joey1984]

Hi,

I have an Excel worksheet which is sent to several stakeholders. Some stakeholders want to print out the spreadsheet but want to be able to print it out as A3 automatically. In other words make the spreadsheet i send out as A3 printer friendly.

The issue is my PC does not have a Printer that has A3 paper size option. So when I try to run macro queries such as

[FONT=&quot]ActiveSheet.PageSetup.Pape[/FONT]<wbr style="font-size: 16px; font-family: "Nunito Sans", sans-serif;">[FONT=&quot]rSize = xlPaperA3

[/FONT][FONT=&quot]Run-time error '1004': Unable to get the [/FONT][FONT=&quot]PaperSize[/FONT][FONT=&quot] property of the PageSetup class

[/FONT]Can someone please advise what macro query i can use to be able to set the spreadsheet as A3 printer friendly so when i send it out others who do have A3 printers can print it out?

 

[Dryver14]

Now I am confused are you sending it out as a macro free workbook?

 

[joey1984]

Yes I am sending it out as a macro free work book