Assign Macro to button in Excel doesnt work Any ideas?

[Guest]

I have followed the instructions in help but when I get to step 3 "right
click to bring up shortcut menu & enter Assign Macro" the assign macro"
option does not appear!! Any Ideas

 

[JulieD]

Hi Mike

can you see assign macro - but it is greyed out? or is it not an option at
all?

if it is greyed out you'll notice around the button little diagonal lines,
click on these and they should go furryish .. now try right mouse clicking.

if the option is not there at all, please post back letting us know how you
created the button.

Cheers
JulieD

 

[Dave Peterson]

There are two different buttons you can place on a worksheet.

One is called a commandbutton and it's from the control toolbox toolbar.

The other is a button from the Forms toolbar.

I'm guessing you used the commandbutton from the control toolbox toolbar. Try
deleting that button and adding a button from the Forms toolbar.