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

Get FREE Advanced Excel Exercises with Solutions!

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


How to Edit a Macro Button in Excel: 5 Suitable Methods

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

In the beginning, we have to create a macro button in Excel. We named it “Run the Macro”.

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.

Read More: Excel Assign Macro to Button


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 other features.


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

Finally, if you wish, you can change the positioning and mobility properties 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).


Download Practice Workbook

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


Conclusion

Therefore, these are the processes to edit a Macro button in Excel. Do you have any questions? Feel free to ask us.

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rifat Hassan
Rifat Hassan

Rifat Hassan, BSc, Electrical and Electronic Engineering, Bangladesh University of Engineering and Technology, has worked with the ExcelDemy project for almost 2 years. Within these 2 years, he has written over 250 articles. He has also conducted a few Boot Camp sessions on effective coding, especially Visual Basic for Applications (VBA). Currently, he is working as a Software Developer to develop and deploy additional add-ins to enhance the customers with a more sophisticated experience with Microsoft Office Suits,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo