ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Macro code behind button (https://www.excelbanter.com/excel-worksheet-functions/253271-macro-code-behind-button.html)

bcm2

Macro code behind button
 
How do I find out what macro and the code assigned to a specific button in an
Excel worksheet? I can view all the macros assigned to the workbook, but it
appears that there may be other macros running on these buttons (my personal
list of macros is empty)(I am the author of the workbook).

Luke M

Macro code behind button
 
Right-click on button, assign macro. See that is assigned.

If an ActiveX control, you may need to click on "view code".


Alternatively, you can bring up the VBE (Alt+F11) and look through the
different parts of your workbook to see what coding is in there.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"bcm2" wrote:

How do I find out what macro and the code assigned to a specific button in an
Excel worksheet? I can view all the macros assigned to the workbook, but it
appears that there may be other macros running on these buttons (my personal
list of macros is empty)(I am the author of the workbook).



All times are GMT +1. The time now is 09:04 AM.

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