Print orientation for UserForm

P

Paul_Godley

New Member
Joined
Sep 5, 2002
Messages
18
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? :rolleyes:
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Sort by date Sort by votes
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Print to last column & row that has data
Replies
1
Views
183
ShawnSPS
S
E
  • Question
VBA for printing multiple tabs excel for mac
Replies
5
Views
118
EBahn
E
M
  • Solved
Print sequential numbers
Replies
7
Views
217
Peter_SSs
Peter_SSs
B
  • Question
Update =getimage() inbetween VBA prints
Replies
0
Views
118
Bajjonetaz
B
Pinaceous
  • Solved
VBA PrintOut to PDF
2
Replies
12
Views
287
Pinaceous
Pinaceous

Forum statistics

Threads
1,214,832
Messages
6,121,843
Members
449,051
Latest member
excelquestion515

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top