Excel macro buttons not working office 2013

#Excel macro buttons not working office 2013 code

The button inserted using this technique is a standard one and you canвЂ™t change the formatting of the button (unlike shapes, where you can change practically everything). This would insert the button in the worksheet.

Select the macro you want to assign to the button and click on OK.

As soon as you do this, it will open the Assign Macro dialogue box.

Developer tab is not visible on the ribbon by default and you may need to add it before using it.

Go to the Developer tab вЂ“> Controls вЂ“> Insert вЂ“> Form Controls вЂ“> Button.

Here are the steps to assign a macro to a button: You can assign a macro to a button and then can run the macro by simply clicking that button. While the shape is something you can format, a button has a standard format. ThatвЂ™s it! Now the shape would work as a button and whenever you click on it, it will run the assigned macro.

In the Assign Macro dialogue box, select the macro you want to assign to the shape and click the OK button.

This opens the Assign Macro dialogue box.

Right-click on the shape and select the Assign Macro option.

You can also insert any text in the shape by simply selecting it and typing the text. In the example above, I have changed the size, color, and border.

Resize/Format the shape the way you want.

It will insert the shape object in the worksheet. Insert any shape to which you want to assign the macro.

In the Illustrations group, click on the Shapes icon.

Even if you share the workbook with someone who has no knowledge of VBA, he/she can just click on the button and see the actions take place (without even knowing what happens in the back end). The benefit of this method is that it makes it really easy and intuitive for anyone to run the macro. One of the easiest ways to run a macro is to have a button in the worksheet and click that button to execute the macro.

Now letвЂ™s see various ways to run this macro in Excel.

#Excel macro buttons not working office 2013 code

This one line code would fill the cell A1 of the active sheet with red color.

Run a Macro from the Ribbon (Developer Tab)ДЇor the purpose of this tutorial, letвЂ™s say we have a macro named вЂColorCellвЂ™ with the following code: Sub ColorCell().