Macro to print worksheet to network printer

[dave8]

I need to print a worksheet and assign to a specific printer on a network. How to accomplish this? I will have a command button, "Print", to send the worksheet to a printer that on a network.

 

[drsarao]

This should work:

Sub PrintToNetwork()
ActiveSheet.PrintOut ActivePrinter:=[COLOR="#FF0000"]"HP Photosmart 7800 Series"[/COLOR]
End Sub

You need to replace the highlighted name with your network printer name as given in the "Printers & Faxes" Control Panel item.