Assign Macro to button

[Guest]

I have created some macros and am trying to assign them to a command button but the option is not available to me. I end up having to right click on button, view code, open my macros and cut and paste the script. This is a pain since I have so many to do. I cant seem to find the command "assign macro to button" o my list.......HELP!!

TI

Chas

 

[Doug Glancy]

Chas,

If you use the button from the "Forms" toolbar, instead of the "Control
Toolbox" toolbar you'll find the option you want.

hth,

Doug

I have created some macros and am trying to assign them to a command

button but the option is not available to me. I end up having to right click
on button, view code, open my macros and cut and paste the script. This is
a pain since I have so many to do. I cant seem to find the command "assign
macro to button" o my list.......HELP!!!

 

[Ken Wright]

Sounds like you took your command button off of the Control Toolbox instead of
the Forms Toolbar

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

I have created some macros and am trying to assign them to a command button

but the option is not available to me. I end up having to right click on button,
view code, open my macros and cut and paste the script. This is a pain since I
have so many to do. I cant seem to find the command "assign macro to button" o
my list.......HELP!!!

 

[libby]

You can assign macros in the manner you describe with
buttons from the Forms toolbar
For buttons from the Control Toolbox toolbar you can call
macros rather than copying and pasting the code.
EG if you have a macro called Macro1
Then in the click event code for the button type
Call Macro1

-----Original Message-----
I have created some macros and am trying to assign them

to a command button but the option is not available to me.
I end up having to right click on button, view code, open
my macros and cut and paste the script. This is a pain
since I have so many to do. I cant seem to find the
command "assign macro to button" o my list.......HELP!!!

 

[JE McGimpsey]

Try using buttons from the forms toolbar rather than the control toolbar.

 

[Guest]

Thanks everyone for your help,much appreciated!