CommandButton Question
Sounds like you're still in design mode and you're double clicking - is that
possible?
Jeff
"Magnivy" wrote in message
...
I inserted a CommandButton into a worksheet. I'm trying to have the
CommandButton run another macro that I have in a different module (Module
4).
The code that I've used is
Private Sub CommandButton1_Click()
Call Module4.MACRO1
End Sub
However, instead of executing the macro, it displays the VBE window for
CommandButton1 (and shows the above code).
How can I have the CommandButton run the macro instead of displaying the
VBE?
Thanks in advance for your help!
Magnivy
|