Print orientation for UserForm

[Paul_Godley]

I have managed to use Printout to print a UserForm, but cannot change the orientation to lanscape.
I have used activesheet.pagesetup.orientation, but cannot get it to work.
Can anyone help please?

 

[erik.van.geit]

we have seen this here before
http://www.mrexcel.com/board2/viewtopic.php?t=47112&highlight=print+form

this link might help
regards,
Erik

 

[Paul_Godley]

Thank you.
I thought that I had worked my way around this by changing the size of the form, but I now need to print the form in landscape.
I have followed your links and copied the code without success.

The line
SavePicture PastePicture(xlBitmap), "C:\Test.bmp"
produces an error with PastePicture not being recognised.
I have tried VBA help for SavePicture and PastePicture but could find no help.

Is there anything that you can suggest please?

Many thanks in advance.
Paul

 

[Juan Pablo González]

PastePicture is a method created by Stephen Bullen, available here:

http://www.bmsltd.ie/Excel/Default.htm