ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   print form orientation (https://www.excelbanter.com/excel-programming/281036-print-form-orientation.html)

Burt[_2_]

print form orientation
 
My first VBA/Excel project uses a form to enter data, a sheet to list
the data, a sheet to paste & sort selected data and a form to analyse
the data. I need to print the analyser form via a cmd button but need
to ensure that it fits the printer page. I am using "frmanalyser.Print
Form" . Can anyone tell me how to set the print orientation in VBA ..
Thanks !!!!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/



All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com