ExcelBanter - printing excel worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - printing excel worksheet (https://www.excelbanter.com/excel-programming/332628-printing-excel-worksheet.html)

Jorge Ribeiro

printing excel worksheet

hello

i want to open an excel worksheet directly to print preview...
i used

app.activeSheet.printPreview

the problem is that when i click the print button within print preview it
opens
the excel application

is there a way to avoid this? to avoid the openning of the excel app?

thanx

Jorge

Dave Peterson[_5_]

printing excel worksheet

Isn't excel already open so that it can run the printpreview?

Jorge Ribeiro wrote:

hello

i want to open an excel worksheet directly to print preview...
i used

app.activeSheet.printPreview

the problem is that when i click the print button within print preview it
opens
the excel application

is there a way to avoid this? to avoid the openning of the excel app?

thanx

Jorge

--

Dave Peterson

All times are GMT +1. The time now is 03:36 AM.