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