View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 98
Default Worksheet ActiveX Objects

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?