ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   View what macro is assigned to a tool bar button (https://www.excelbanter.com/excel-programming/442768-view-what-macro-assigned-tool-bar-button.html)

C

View what macro is assigned to a tool bar button
 
How do I view which macro is assigned to a custom button?

JLGWhiz[_2_]

View what macro is assigned to a tool bar button
 
Right click the button. If the pop-up menu appears with the option to
assign a macro, then select that option. If a macro is assigned, it will
appear in the top window, shaded. If none is assigned it will appear as
Button1_Click, Or whatever button number it happens to be.

If the pop-up menu does not appear when you right click the button, then the
button is from the Control Tool box and you will need to enter design mode
to access the code for the button. Once in design mode, right click the
button and select "View Code" from the pop-up menu. That is that the
CommandButton_Click code is the code for that button.



"C" wrote in message
...
How do I view which macro is assigned to a custom button?





All times are GMT +1. The time now is 06:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com