Assign to macro missing

[Paul]

Hi
I am using Excel 2000 and the "assign to macro" menu doses not appear. I want to assign a
macro to a button, I am sure I have done this in the past but cannot get the menu to
appear. Right click over sizing handles on button and menu appears but assign to macro
missing.
Anybody help.

Many thanks

Pal

 

[Paul]

Hi
I am using Excel 2000 and the "assign to macro" menu doses not appear. I want to assign
a macro to a button, I am sure I have done this in the past but cannot get the menu to
appear. Right click over sizing handles on button and menu appears but assign to macro
missing.
Anybody help.

Many thanks

Pal

Sorry correction version of Excel is 2003

 

[Bob Phillips]

Paul,

Make sure that you use the button from the Forms toolbar, not the Control
toolbox toolbar.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Paul]

Bob

So quick and so accurate many thanks for your help.

Paul