ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   OLE Page Setup Question (https://www.excelbanter.com/excel-programming/278295-ole-page-setup-question.html)

Malissa

OLE Page Setup Question
 
I'm using OLE to automate Excel. I am able to set the FitToPagesWide
and FitToPagesTall properties, BUT...

Unlike setting these properties manually, the "Fit to:" setting is
not automatically activated just because those properties are set. So
even though I can set those properties, they do nothing when the user
prints out the page because the "mode" is still set to ."Adjust to:"

How can I activate the "Fit to" mode with OLE?

Thanks for any help!!


All times are GMT +1. The time now is 09:29 PM.

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