not getting the "assign macro" shortcut

[JC Home]

Hi all,

I have created a macro and would like to assign it to a button, but when I
create the button and right click, I don't get an option to assign a macro.
Anybody know why this isn't working and how to correct it?

Thanks!!

 

[Gord Dibben]

If you created a button using the Control Toolbox Toolbar, you right-click on
the button and "View Code".

Paste your code in there.

If you create a button from the Forms Toolbar right-click and "Assign Macro".

Gord Dibben Excel MVP

 

[JC Home]

That's it. I can't tell the different buttons apart on the toolbar

 

[Gord Dibben]

Glad you're sorted out.

Very common problem with these buttons.

Gord