Make sure you add the Developer ribbon in Excel (Tools, Options). Record your macro to print. Exit the recorder. After you have recorded your macro, go to the Developer ribbon. Then go to the Controls section of the Developer ribbon, then click on the Insert Controls dropdown, and select the Button (Form Control) option. Assign your macro to this button and give your button a label like: "Click here to print", and you're good to go.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
