Cannot assign a macro using right-click

C

Cuyahogen

Hi everybody,

I am running Excel 2000 and would like to assign macros to buttons i
some of the spreadsheets that I use.

Right-click works, but there is no option to assign a macro.

Somehow the button I create always becomes an ActiveX control - don'
know if this is relevant.

Any help or advice gratefully received
 
D

dominicb

Good afternoon Cuyahogen

Have you designed the buttons from the Control Toolbox? If so the cod
needs to be placed as an event in the appropriate worksheet space in th
VBE.

However, if you want to use the assign macro feature, scrap the button
you've got and design your buttons again using the Forms toolbar. Thes
buttons will have the Assign command in the right click menu.

HTH

Dominic
 
B

Bob Phillips

It is indeed. You have the controls toolbar showing, not the forms toolbar.

Go to Tools>Customize>Toolbar and click Forms, then select your button from
there.
 
C

Cuyahogen

Thanks to both.

You were right, of course. I have now brought up the 'forms' toolbar
and 'assign macro' is there - but it's greyed-out!

Is there any way I can ungrey it without being an administrator?

Thanks again
 
Top