I have an odd problem.
I no longer have the option to assign macros in the right-click contex
menu.
When I create a custom button on an excel sheet and then enter desig
mode, usually you can just record a macro, right click a button an
assign a macro. I cant seem to find the option to assign macros t
buttons! :confused:
Any help on enabling this option in the right-click contextual men
would be much appreciated.
Regards
Gord Dibben - 03 Jul 2006 21:33 GMT
If you create the button using the Forms Toolbar you will get the "Assign Macro"
available.
When creating using the Control Toolbox, you must right-click on the button and
"View Code".
Add your macro code there.
Gord Dibben MS Excel MVP
>I have an odd problem.
>
[quoted text clipped - 9 lines]
>
>Regards.
paperclip - 03 Jul 2006 21:47 GMT
Genius! That was exactly it!
Thank you!!
Gord Dibben Wrote:
> If you create the button using the Forms Toolbar you will get the
> "Assign Macro"
[quoted text clipped - 22 lines]
> >
> >Regards.

Signature
paperclip