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" <Nigel@discussions.microsoft.com> wrote in message
news:2775F79D-8297-40F7-977F-86E6C6331C09@microsoft.com...
> 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?