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.
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.
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.
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.
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.
A new Module in the Visual Basic window will open to create a new Macro.
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.
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.
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.
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).
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.