Hello,
I would like to create controls on different sheet.
But have the event code in the main workbook. And have none in the
worksheets.
Is this possible?
Where I could have a
Workbook_<SOMETHING> event.
Then have a case statment looking for the control name.
If it was CommandButton1 on sheet1 I would look for CommandButton1.
If it was CheckBox1 on sheet5, I would look for CheckBox1.
is this possible?
thanks

I thought I could use the WithEvents
so in my workbook have
Private WithEvents CmdBut As CommandButton
then
Private Sub CmdBut_Click()
MsgBox "in thisworkbook"
End Sub

but this does not work

Any help?
thanks


"greg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
> I would like to create controls on different sheet.
> But have the event code in the main workbook. And have none in the
> worksheets.
> Is this possible?
> Where I could have a
> Workbook_<SOMETHING> event.
> Then have a case statment looking for the control name.
> If it was CommandButton1 on sheet1 I would look for CommandButton1.
> If it was CheckBox1 on sheet5, I would look for CheckBox1.
> is this possible?
> thanks
>