Print Button On excel

[saadferoze]

I would like to add a print button on excel sheet, so i can click it and sheet gets printed. What code should io assign to button if name of button is PRINT. Please suggest


Regards

Saad

 

[Hui]

Saad


Just a simple macro will do it

[pre]

Sub PrintMe()
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub

[/pre]

The above assume you have already defined a Print Area and have the default printer setup correctly


Then assign the Macro to your Button

 

[saadferoze]

Thanks hui,


It has worked.


regards

Saad