Assigning Macros

[Guest]

Sometimes - When I'm trying to assign a macro to a control button, I right
click and the "assign macro" option is not available. Can anyone tell me why
and what I can do to fix it?

Regards,
Randy

 

[Guest]

Should always be available on a Forms button

 

[Chip Pearson]

Randy,

It depends on the type of control button you are using. If you are using
command buttons from the Forms command bar, you should be able to use
"Assign Macro". If you are using command buttons from the Controls menu, you
can't assign macro to the button. Instead, choose View Code from the
right-click menu and call your code from that event procedure.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Guest]

Perhaps but it's not.........

Should always be available on a Forms button

 

[Guest]

Thanks Chip.......works perfectly now. Have a great day!