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

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

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

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 :)