Hello,
I want a command button on a worksheet that calls an error checking macro. Since I use this error check macro on more than one worksheet I put the code in a module, rather than duplicate the code in each worksheet.
I'm using Excel 2007 and there are two ways to create the command button. Form Controls and ActiveX Form Controls. I'd like to spruce up the button, at least with a color different than gray. So, I used the ActiveX form control Command Button. I did spruce it up a bit, but then I can't link it to my error checking macro, which I put in a module. If I use an old fashioned Form Control Command Button, I can link it to the macro in the module but I can't spruce the button up.
Normally, I'm a function over form kind of guy, but in this case I'd like a little more form with the same function.
The question is how can I link the macro code in a module to an ActiveX Command Button?
Thanks for your help.
George Teachman
I want a command button on a worksheet that calls an error checking macro. Since I use this error check macro on more than one worksheet I put the code in a module, rather than duplicate the code in each worksheet.
I'm using Excel 2007 and there are two ways to create the command button. Form Controls and ActiveX Form Controls. I'd like to spruce up the button, at least with a color different than gray. So, I used the ActiveX form control Command Button. I did spruce it up a bit, but then I can't link it to my error checking macro, which I put in a module. If I use an old fashioned Form Control Command Button, I can link it to the macro in the module but I can't spruce the button up.
Normally, I'm a function over form kind of guy, but in this case I'd like a little more form with the same function.
The question is how can I link the macro code in a module to an ActiveX Command Button?
Thanks for your help.
George Teachman