ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   not getting the "assign macro" shortcut (https://www.excelbanter.com/excel-programming/312254-not-getting-assign-macro-shortcut.html)

JC Home[_2_]

not getting the "assign macro" shortcut
 
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!!

--
Jeff Ciaccio
Dallas, GA



Gord Dibben

not getting the "assign macro" shortcut
 
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

On Sat, 2 Oct 2004 17:36:11 -0400, "JC Home" wrote:

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!!



JC Home[_2_]

not getting the "assign macro" shortcut
 
That's it. I can't tell the different buttons apart on the toolbar :)

--
Jeff Ciaccio
Dallas, GA
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

On Sat, 2 Oct 2004 17:36:11 -0400, "JC Home" wrote:

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

not getting the "assign macro" shortcut
 
Glad you're sorted out.

Very common problem with these buttons.

Gord

On Sat, 2 Oct 2004 17:48:25 -0400, "JC Home" wrote:

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




All times are GMT +1. The time now is 11:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com