Custom Buttons

[Tony]

Hope I'm in the right place. If not please re-direct me.

I have written some macros and assigned them to custom buttons.
As I got a bit more used to VBA, I re-named the module and now the buttons
can't find the macro's any more (to be expected I guess)

a) Is there a way to discover exactly what macro a button has assigned to
it?
and
b) Is there a way to re-assign a different (well, re-named) macro to an
existing custom button?

TIA
Tony

 

[jesse]

Tony,

I've yet to find a way to determine exactly what macro is
assigned to a button once you assign it. If you right
click the button you are taken to a sub-menu that does not
indicate the assigned macro.

When I've encountered this problem in the past I've found
it much quicker to delete the button and create a new one,
because it only takes seconds to do so.

First make sure the macros you want to assign to the
customized buttons are resident in the assigned template
or the document. If they are not, copy them using the copy
feature, or copy and paste them using the editor.

I hope this helps.

J

 

[Tony]

Yeah, thanks Jesse. I feared there might not be a way.

I thought I might be able to simple re-assign a new macro to an existing
button to avoid...

Drag the new macro to the toolbar
Copy the button image from the old button
Paste it to the new button
Coose default style for the new button
Re-name the button to remove the long macro path
Delete the old button

Do all the above about a dozen times...
<sigh>
I'm tough, I can do this...

cheers