Assign to macro missing

  • Thread starter Thread starter Paul
  • Start date Start date
P

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 said:
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
Click to expand...
Sorry correction version of Excel is 2003
 
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)
 
Back
Top