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.