Assign Macros to Buttons from Right-Click Menu

  • Thread starter Thread starter paperclip
  • Start date Start date
P

paperclip

I have an odd problem.

I no longer have the option to assign macros in the right-click contex
menu.
When I create a custom button on an excel sheet and then enter desig
mode, usually you can just record a macro, right click a button an
assign a macro. I cant seem to find the option to assign macros t
buttons! :confused:

Any help on enabling this option in the right-click contextual men
would be much appreciated.

Regards
 
If you create the button using the Forms Toolbar you will get the "Assign Macro"
available.

When creating using the Control Toolbox, you must right-click on the button and
"View Code".

Add your macro code there.


Gord Dibben MS Excel MVP
 
Genius! That was exactly it!

Thank you!!

Gord said:
If you create the button using the Forms Toolbar you will get the
"Assign Macro"
available.

When creating using the Control Toolbox, you must right-click on the
button and
"View Code".

Add your macro code there.


Gord Dibben MS Excel MVP
Click to expand...
 

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

How to record a macro within a macro 9
Problem Assigning Macro to Button 3
Assign a Macro to a Command Button 1
Cant assign macro to command button 5
Inserting cells (shift cells right) using macro 0
Macro Button 2
Assigning a macro to a button 5
attaching a macro to a control button in the Quick Access Toolbar 1

Back
Top