![]() |
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 |
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!! |
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!! |
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