Why not just use Option Buttons instead of Check Boxes. They only allow one
to be checked at a time?

HTH

"Xavierskyrider" wrote:

Im doing an excel sheet for work and need to program a macro so that say when
two checkboxes are checked at the same time it unchecks them and creates a
message box signifying an error. Maybe even have it play a sound too