please help me in Printing Case

[Exhumes]

How can use a VBA Button exist on Sheet 1 to print sheet 2 for specific printer

your help is highly appreciated

Regards,
Ex

 

[itlsbu]

Hello,

With the toolbar "forms" you can create a button on a sheet. Right-clicking you can assign a macro to it.
the macro for printing can be created by using the recorder "tools/macro/record new macro" and just do what you would do manualy. It would look something like below

Sub Macro1()

Sheets("Sheet2").Select
Application.ActivePrinter = "name of printer"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Sheet1").Select

End Sub

 

[Exhumes]

Many Thnaks Mr.

you have helped me very well.


regards,
Ex