Hi Harold,

Try something like:

'=============
Private Sub CheckBox1_Click()
'Yourcode
CheckBox1.Enabled = False
End Sub
'<<=============

---
Regards,
Norman



"Harold Good" wrote in message
...
Hi, I don't know VBA but I recorded and copied three macros into code and
they are activated by three ActiveX Option Buttons. The buttons allow the
user to chose the type of project for which they will be entering data.

But once they choose the type, I'd like to use a trigger event to deactive
the code so they can no longer click on an Option Button and thus loose
their data.

How is the best way to do this? Hopefully there is a simple way to have
the Option Buttons gray out and lose focus so they can't be clicked
anymore. It should be all or nothing, all three are active or all three
are inactive, never a combination of some on and some off.

Can someone point me in the right direction?

If it requires a bit of code, could you please help me with that?

Many thanks,

Harold