Changing Default Printer Preferences from VBA

[Rhadida]

I was wondering if it is possible to change the Default Printer Preferences (e.g. Landscape/Portrait). Or to force Excel to print Landscape/Portrait?

I am trying to figure out a way to print a Userfrom in Landscape, but I can't seem to find any solotion to the problem. Anyone got some new information on the subject?

 

[SydneyGeek]

You could use

ActiveSheet.PageSetup.Orientation = xlLandscape or
ActiveSheet.PageSetup.Orientation = xlPortrait

as required

Denis

 

[Rhadida]

The ActiveSheet option only changes the print format to Landscape when printing Sheets, unfortunately it doesn't apply to printing Userform.

Anymore suggestions? Perhaps a change in the VB settings?

 

[SydneyGeek]

How often will you be printing the form? If not often, maybe you can select the form, Ctrl + Print Screen and paste to a blank worksheet (or to Word). Then you can set the orientation.

Just a thought...

Denis

 

[Rhadida]

The printform function is used to print a Userform with data a User has selected. So people will be using the press on a button to print the form. they don't have any knowledge of excel, so I was looking for a Print option to Landscape, so the form will fit on the page

But thanks for your input.


Does anyone perhaps know if an add-in could be created to set the printer defaults?

 

[Andrew Poulsom]

Follow the Google link posted here:

http://www.excelforum.com/archive/index.php/t-249746.html

 

[Rhadida]

Follow the Google link posted here:

http://www.excelforum.com/archive/index.php/t-249746.html

Thanks I'll try that code out