What macros are assigned to icons?

T

Terry Pinnell

I have several icons in my Excel 2000 toolbar whose purpose I'm vague
about. When I made them some years ago I carelessly failed to
customise their pop-up text, so several just read 'Custom Button'. And
so far I've not discovered how to find what macros they run - apart
from the risky approach of actually trying them! Could someone kindly
remind me please?
 
J

JE McGimpsey

One way is to right-click the button and choose Assign Macro. The macro
name, if one is assigned, will be in the dialog's "Macro Name" field.

Alternatively, you can enter something like this in the immediate window:

? Commandbars("MyBar").Controls(14).OnAction

Change the name of your toolbar and the control index number to suit.
 
R

Ron Coderre

Try this:

Tools|Customize (or Right-click in the gray area at the top of the window).
Select: Customize
Right-click on the button
Select: Assign macro
The macro assigned to the button should be the default selection.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
T

Terry Pinnell

Ron Coderre said:
Try this:

Tools|Customize (or Right-click in the gray area at the top of the window).
Select: Customize
Right-click on the button
Select: Assign macro
The macro assigned to the button should be the default selection.

Does that help?
Click to expand...

Thanks both, got it - and embarrassed I didn't see that myself! I had
looked at that box, for several icons, but only saw as far as:
'C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART\PERSONAL.XLS'

If I'd panned rightwards I'd have seen that they weren't all the same,
as I first thought, but contained the macro name at the end, like:
!CheckFirst
!Surf9
etc
 
Top