Hi Paul,



I know, that I don't need Forms Protection with content controls.

I use it because it seems to be 'the lesser evil'. My users have been clicking on ActiveX radio buttons for lots of years now. They are used to one click = immediate change, which is the common behavior for radio buttons. They simply DO NOT WANT to click elsewhere before the change is triggered. And - to be honest - I can understand them.

So I though it might be a solution to use content control check boxes (with the almost appearance of radio buttons). But the problem now is, that whenever they (the users) click a check box, they either have to cope with
a) Forms Protection on: selection changes to next check box = not the radio button behavior they are used to, OR
b) Forms Protection off: they have to click somewhere else to trigger the on exit event = again not the radio button behavior they are used to.

Why shouldn't that be possible: Forms Protection selects the next check box without doing 'any harm'. You can click that check box or click another. Re-selection would just be another on entry - or am I wrong ...

Right now, I am not happy with any of the solutions - the users neither. If it wouldn't take 10 seconds (or more) to open the document with the radio buttons, I would stick to the ActiveX buttons (in that case). Maybe I'm a bit stubborn, but I'd like to have a solution, the users enjoy working with.

BTW: do you kow why Word needs 10 seconds to open a document with 136 grouped radio buttons, while Excel needs less than one?

NP

The only thing that isn't instantaneous is the recalc - as soon as you click on a checkbox, it changes state. And, if it's a form with multiple checkboxes, I'd have thought the only time the recalc issue might matter is when the last checkbox is checked. Quite obviously, you need to ensure that one gets exited.

Whether you're using
a) Forms Protection; or
b) Editing restrictions; or
c) no restrictions,
nothing happens until you exit the checkbox.

No, you don't need an on-entry macro. Rather, the on-exit one can handle the re-selection. That will trigger the on-entry macro of its own accord. BUT... Visualize this -
1. Select Checkbox
Do While not tired
2. Exit Checkbox
3. Macro kicks in
4. Checkbox re-selected
Loop
No, but I do know it's old technology that MS moved away from long ago. It's probably only being retained for backwards compatibility and may be deprecated in another version or two.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Just some feedback

But many of the users I know still use and love radio buttons. Unfortunately there is no appropiate replacement for them ...

After some lengthy discussions we will implement the evaluation sheet in Excel. A decision that moves the radio button issue to a formatting issue ... .

Cheers
NP