ExcelBanter - Printing button in excel 2003

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Printing button in excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/257819-printing-button-excel-2003-a.html)

Neil Holden

Printing button in excel 2003

Hi all, is it possible to create a button to print to a certain printer?
Please bear in mind this is not my default printer?

Help would be much appreciated.

Jacob Skaria

Printing button in excel 2003

'Why not leave this with user to select

Application.Dialogs(xldialogprint).show

OR

ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"\\server\prntername:", Collate:=True
--
Jacob

"Neil Holden" wrote:

Hi all, is it possible to create a button to print to a certain printer?
Please bear in mind this is not my default printer?

Help would be much appreciated.

Neil Holden

Printing button in excel 2003

Helpful as always Jacob.

Is this your full time job?

Neil.

"Jacob Skaria" wrote:

'Why not leave this with user to select

Application.Dialogs(xldialogprint).show

OR

ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"\\server\prntername:", Collate:=True
--
Jacob

"Neil Holden" wrote:

Hi all, is it possible to create a button to print to a certain printer?
Please bear in mind this is not my default printer?

Help would be much appreciated.

All times are GMT +1. The time now is 05:32 AM.