Cannot assign a macro using right-click
 

Hi everybody,

I am running Excel 2000 and would like to assign macros to buttons in
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't
know if this is relevant.

Any help or advice gratefully received.


--
Cuyahogen
------------------------------------------------------------------------
Cuyahogen's Profile: http://www.excelforum.com/member.php...o&userid=25478
View this thread: http://www.excelforum.com/showthread...hreadid=389310

Good afternoon Cuyahogen

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

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

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=389310

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

Go to ToolsCustomizeToolbar and click Forms, then select your button from
there.

--
HTH

Bob Phillips

"Cuyahogen" wrote
in message ...

Hi everybody,

I am running Excel 2000 and would like to assign macros to buttons in
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't
know if this is relevant.

Any help or advice gratefully received.


--
Cuyahogen
------------------------------------------------------------------------
Cuyahogen's Profile:
http://www.excelforum.com/member.php...o&userid=25478
View this thread: http://www.excelforum.com/showthread...hreadid=389310

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.


--
Cuyahogen
------------------------------------------------------------------------
Cuyahogen's Profile: http://www.excelforum.com/member.php...o&userid=25478
View this thread: http://www.excelforum.com/showthread...hreadid=389310

Please ignore my last post. It works! It works!


--
Cuyahogen
------------------------------------------------------------------------
Cuyahogen's Profile: http://www.excelforum.com/member.php...o&userid=25478
View this thread: http://www.excelforum.com/showthread...hreadid=389310