'Assign Macro' dialog missing in Excel XP

S

Simon Dau

I'm trying to assign a macro to a command button, however
the 'Assign Macro' dialog is missing from the context
menu when right clicking the button. I have only been to
do it when having opened an old worksheet (created in
excel 97) with existing command buttons & macros, then
the option is there to assign a macro.

I have searched the net for a solution however to no
avail. I know it is possible since Excel Help states that
is the official way to do it. I have office Xp installed
with service pack 2.

I hope you will be able to help me.

Thank you
 
B

Bill Lunney

It's possible your using the ActiveX style command buttons. These differ in
behaviour from the other forms style buttons.

To use the assign macro type buttons make sure you are selecting a command
button from the FORMS toolbar NOT the 'control toolbox'.


--
Regards,


Bill Lunney
www.billlunney.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Change a great number of words in word files, with a macro as short as possible. 5
Use Macro To Change Which Macro Assigned To Command Button 0
Excel 2007 Command button 3
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
Assign Macro Dialog Box 6
Assign Function to a Command Button 1
Excel 2003 - assign macro to custom toolbar button 1

Top