BUTTON CONTROL 4

[gc1234]

Hi

How do i create a control button so i can assign it to a modlue sub function? I've created the button but the option assign macro is not available

 

[WAHMom]

Can you just double click your newly created button and get the "Assign Macro" box? That works for me in Excel 2003.

 

[gc1234]

Well, I paint a button on the screen and do not get that option>>?

 

[bluedragon2]

In design mode, right click on the button and choose view code. You can put your code there or call another piece of code.



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[gc1234]

mmmmh, I'll give it a whirl, surely that would open the code for that sheet would it not?

 

[Corgano]

There are two toolbars to get a button from.

Forms and Control Toolbox.

The "Forms" button will allow you to assign a macro, the "Control Toolbox" button won't.

I'm betting this is the source of your problems!
Goodluck!

 

[gc1234]

I seeeeeeeeeeee., thxs