Radio buttons are a neat way to enable only one thing to be selected. The downside is that you need to add macros on the back end to make them work. The tutorial below (recorded in Excel 2007, but 2003 options also explainded) offers you a way to use data validation to ensure that only [...]

Actually, I do like macros, used in the right place at the right time.  Excel macros can be incredibly powerful, but I try to avoid using them if possible. Why? Well, there are several reasons: Undo – There are a few things that break the ‘undo’ chain, by which I mean that you can’t undo [...]