ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Print Excel Document using right mouse click (https://www.excelbanter.com/excel-discussion-misc-queries/113851-print-excel-document-using-right-mouse-click.html)

Randesonzz

Print Excel Document using right mouse click
 
I am trying to setup the File Options for MS Excel 2003 so that it will print
a WHOLE workbook. That is, currently the right-mouse print will only print
the active page that the Excel workbook at the time of save.

This print command uses DDE and the following string is passed to Excel for
printing -

[open("%1")][print()][quit()]

Is there a way to tell it to print the entire workbook?

Thanks.

Bob Anderson


All times are GMT +1. The time now is 02:16 PM.

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