ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I know what macro is assigned to a button? (https://www.excelbanter.com/excel-discussion-misc-queries/81111-how-do-i-know-what-macro-assigned-button.html)

Denise in NC

How do I know what macro is assigned to a button?
 
I forgot which macro I assigned to a button. How can I figure this out?

Infinity

How do I know what macro is assigned to a button?
 

Right click on the button and select Assign Macro.

Denise in NC Wrote:
I forgot which macro I assigned to a button. How can I figure this out?



--
Infinity
------------------------------------------------------------------------
Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725
View this thread: http://www.excelforum.com/showthread...hreadid=529080


Denise in NC

How do I know what macro is assigned to a button?
 
Thanks for the reply :-)

When I do that, I get a drop down menu with many macros listed. Shall I
assume that the one at the top of the list is the one that is assigned?

Denise

"Infinity" wrote:


Right click on the button and select Assign Macro.

Denise in NC Wrote:
I forgot which macro I assigned to a button. How can I figure this out?



--
Infinity
------------------------------------------------------------------------
Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725
View this thread: http://www.excelforum.com/showthread...hreadid=529080



Tom Ogilvy

How do I know what macro is assigned to a button?
 
I get a listbox with many macros listed as well, but at the top in a separate
textbox (Macro Name:) is listed the macro assigned.

--
Regards,
Tom Ogilvy


"Denise in NC" wrote:

Thanks for the reply :-)

When I do that, I get a drop down menu with many macros listed. Shall I
assume that the one at the top of the list is the one that is assigned?

Denise

"Infinity" wrote:


Right click on the button and select Assign Macro.

Denise in NC Wrote:
I forgot which macro I assigned to a button. How can I figure this out?



--
Infinity
------------------------------------------------------------------------
Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725
View this thread: http://www.excelforum.com/showthread...hreadid=529080




All times are GMT +1. The time now is 12:07 AM.

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