prabhadixit
06-13-2008, 01:13 PM
Hi,
I?m new to VBA and have a question on printing through a macro. I want to put a ?Print?Command button on my worksheet and when this button is clicked, I want the worksheet to be printed or the print dialog box to open. How do I do this? I have created the command button and hence have the Private Sub CommandButton1_Click() created. But what should I code inside this sub? Also how do I change the text on the Command button?
Thanks
I?m new to VBA and have a question on printing through a macro. I want to put a ?Print?Command button on my worksheet and when this button is clicked, I want the worksheet to be printed or the print dialog box to open. How do I do this? I have created the command button and hence have the Private Sub CommandButton1_Click() created. But what should I code inside this sub? Also how do I change the text on the Command button?
Thanks