Landscape macro

  • Thread starter Thread starter uj
  • Start date Start date
U

uj

I need to be able to have my macro change from landscape
to portrait and back when I use my print macro. Any
ideas how to do this?

Thanks
 
One way:
You could put an InputBox in your print macro. When it pops up you
would enter P or L or whatever you want to use. Then add code to the macro
to change the setup accordingly. HTH Otto
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel charts will not go back to Landscape when selected 2
Word Printing and Rotation of Landscaped Pages 2
Landscape selected but printout persists in portrait. How to fix? 1
Printing landscape and portrait 3
Print Landscape/Portrait based on level of grouped data selected 4
how can I print more than 8 columns on a page? 2
Wierd printing requirements between worksheets! 1
Excel 2007 Landscape Orientation 6

Back
Top