I have a macro button in excel and how to find that macro name in excel

Help Studio
, ,
1

Hi ALL,

so have a excel file which contains Macro code and which is present as button on sheet 1 and if press that button(Validate) we can see the result in sheet 2.

This image shows a partially obscured spreadsheet with visible buttons labeled "Validate," "Quality check," and two filepath references annotated with redacted text. (Captioned by AI)
This image shows a partially obscured spreadsheet with visible buttons labeled "Validate," "Quality check," and two filepath references annotated with redacted text. (Captioned by AI)747Ă—773 16.1 KB

so my question is how to find that macro name used for Validate button.

Thank you!

2

@victoryv4569

Please try as below:

To locate the macro name linked to a button in an Excel spreadsheet, follow these steps:

Open the Workbook–>Access the Excel file containing the button.
Enable the Developer Tab–>If it’s not visible, enable it via File > Options > Customize Ribbon, then check “Developer”.
View Button Properties–> Activate “Design Mode” under the Developer tab, right-click the “Validate” button on Sheet 1, and select Assign Macro....
Check the Macro Name–>The assigned macro name will be displayed in the “Assign Macro” dialogue.
Explore the Macro Code–> To view the macro’s functionality, open the VBA editor via the Developer tab or by pressing Alt + F11, navigate to Modules, and locate the macro name.

By following these instructions, you can identify and examine the macro linked to the “Validate” button.

3

@victoryv4569,

Right click on the macro button and click Assign macro.

The image shows a context menu in a spreadsheet application with the "Assign Macro" option circled in red. (Captioned by AI)
The image shows a context menu in a spreadsheet application with the "Assign Macro" option circled in red. (Captioned by AI)387Ă—720 18.4 KB

On next screen, here would be your macro name.

The image shows an Excel "Assign Macro" dialog box where a user is assigning a macro named "Book1!Oval1_Click" to an oval shape. (Captioned by AI)
The image shows an Excel "Assign Macro" dialog box where a user is assigning a macro named "Book1!Oval1_Click" to an oval shape. (Captioned by AI)866Ă—515 23 KB

Remember: If your macro file is password protected, you will have to unprotect it then only it will be visible.

Thanks,
Ashok :slight_smile:

4

Hi @ashokkarale

so Button is the Macro name, Please kindly confirm.

The image shows an "Assign Macro" dialog box in Excel with a list of macros and a specific macro named "button" selected from the workbook "input template prod CANCEL Sample 2.xlsm." (Captioned by AI)
The image shows an "Assign Macro" dialog box in Excel with a list of macros and a specific macro named "button" selected from the workbook "input template prod CANCEL Sample 2.xlsm." (Captioned by AI)680Ă—565 13.9 KB

Thank you!

5

@victoryv4569,

Yes, You can click on edit and it should open the Code editor pointing to the Sub or Function named button

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.