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!