Hi Bob
Dug in a little bit more and discover that having clicked the option button,
it remains in focus and the protection fails. Similar to the problem of a
control button TakeFocusOnClick being left as True.

I am using xl97 as the target application version of Excel

--
Cheers
Nigel



"Bob Phillips" wrote in message
...
Nigel,

I am not sure I quite get the problem, but I added a couple of option
buttons that protect and unprotect fine.

Am I missing a step perhaps?

--
HTH

Bob Phillips

"Nigel" wrote in message
...
Hi All
I have an application that uses an unprotect / protect process before a
user
wish to make changes.

I have a number of control buttons on the sheet (not userform) that when
clicked, intiate an unprotect - sheet(s) update - protect process. This
works OK.

I have now added some option buttons, which uses the clcik event to
intiatie
the same process, however now I get an error arising form the unprotect
process. It appears that the unprotect fails due to the control button
being
active (having clicked it). The control buttons have the
TakeFocusOnClick
set to false, but there does not appear to be a similar option for
OptionButtons?