S saadferoze New Member Mar 21, 2012 #1 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
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 Excel Ninja Staff member Mar 21, 2012 #2 Saad Just a simple macro will do it [pre] Code: 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
Saad Just a simple macro will do it [pre] Code: 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