change printer settings

Guessed · #4 07-20-2020, 04:09 PM

The code you would need is
MsgBox ActiveSheet.PageSetup.PaperSize

Did you do the pre-steps?

Quote:

There is no way to create custom paper sizes in Excel, however you can create custom paper sizes on many printers. Under Page Setup, click the Options button. This will bring up the printer properties dialog box. Change your paper size to a custom size using this dialog box and click OK.

Then in Excel run this: MsgBox PageSetup.PaperSize. This will give you the new constant value assigned to that paper size in Excel. Then change .PaperSize = xlPaperUser in your macro to .PaperSize = & whatever the constant is that you just found.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I lock printer paper size in Word docs saved to PDF?	bwofficer	Word	6	08-24-2017 12:30 AM
Can we NAME our own paper size that will show up on the printer?	FearlessStamper	Word	1	09-10-2016 03:23 PM
Exporting a Large Paper Size as a Single PDF Page	JamesEddy	Word	1	01-05-2016 11:23 AM
Custom page size settings	ibclare	Publisher	0	10-27-2014 08:34 PM
how change size font to inches size	kkepo	Word	4	08-28-2012 08:53 PM