Do this as a test: Open a new workbook (you don't have to save it; this is just practice. Insert a shape that you can edit to look like any button you please. Right click in the shape to edit text: Use something like "Print report". Next, right click inside the button and select Assign Macro. Record your macro. For practice, do something simple, like: Select a cell > type "That's easy!" in the cell > Press Enter . Stop recording. Now, test it by clearing the contents of the cell, and watch what happens when you click on the button. Have fun with it!
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.