How to Edit a Macro Button in Excel (5 Easy Methods)

In this article, I’ll show you how you can edit a Macro button on your worksheet in Excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


5 Suitable Methods to Edit a Macro Button in Excel

Here I’ve got an Excel worksheet with a Macro button called Run the Macro in it.

Excel Worksheet to Edit a Macro Button in Excel

Our objective today is to learn to edit the properties of this button in Excel.


1. Edit Display Text of a Macro Button in Excel

First, we’ll learn to edit the display text of a Macro button. Here the text is “Run the Macro”. Let’s try to change it to “Click the Button”.

To change the display of the button, right-click on the button and then select Edit Text.

Changing the Display to Edit a Macro Button in Excel

You’ll find a cursor placed between the display of the button. Now you can change the display. I’ve changed it to “Click the Button”.


2. Change the Assigned Macro of a Macro Button in Excel

You can also change the assigned Macro with a Macro button. Let’s change the assigned Macro of this button to the Macro called Run_Macro.

Right-click on the button. Then select Assign_Macro.

Assigning a New Macro to Edit a Macro Button in Excel

A dialogue box called Assign_Macro will open. Choose the Macro that you want to assign. Here I’ve chosen the Macro named Run_Macro.

Assign Macro Dialogue Box to Edit a Macro Button in Excel

Then click OK. The chosen Macro will be assigned to the button. Now if you click the button, the Macro will run.


3. Create or Record a New Macro for the Macro Button in Excel

You can also create or record a new Macro for the Macro button.

Again right-click on the button. Then select Assign_Macro again.

The same dialogue box called Assign_Macro will open. To create a new Macro, press on New.

Assign Macro Box to Edit a Macro Button in Excel

A new Module in the Visual Basic window will open to create a new Macro.

Creating a New Macro to Edit a Macro Button in Excel

Or to record a new Macro, click on Record.

Now, whatever you do, will be recorded as a new Macro and assigned to the button.

After you are done with recording, press Stop Recording to finish the recording process.

Stopping Recording Macro to Edit a Macro Button in Excel


4. Edit Format of the Macro Button in Excel

You can change the format of the Macro button according to your wish. Right-click on the button, then choose Format Control.

Changing the Format to Edit a Macro Button in Excel

A dialogue box called Format Control will open all the features available. Choose your desired format from the Font, Alignment, Size, Margin, Properties, and the other features.


5. Change Positioning and Mobility of the Macro Button in Excel

Finally, if you wish, you can change the positioning and mobility property of the Macro button. To do that, right-click on the button and select Format Control.

Format Control Dialogue Box to Edit a Macro Button in Excel

From the Format Control dialogue box, select Properties. You’ll get 3 properties under the Object Positioning feature.

By default, the second property is selected, which allows the Macro to change its position with a cell, but not size.

If you want you can allow it to change both the position and the size (By selecting the 1st one), or neither the position nor the size (By choosing the 3rd one).


Conclusion

Therefore, these are the processes to edit a Macro button in Excel. Do you have any questions? Feel free to ask us. And don’t forget to visit our site ExcelDemy for more posts and updates.

Rifat Hassan

Rifat Hassan

Hello! Welcome to my profile. Here I will be posting articles related to Microsoft Excel. I am a passionate Electrical Engineer holding a Bachelor’s degree in Electrical and Electronic Engineering from Bangladesh University of Engineering and Technology. Besides academic studies, I always love to keep pace with the revolution in technology that the world is rushing towards day by day. I am diligent, career-oriented, and ready to cherish knowledge throughout my life.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo