Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet ActiveX Objects
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet ActiveX Objects
Hi Bob,
Not sure I get it either! But the code I use to lock unlock / lock the worksheets and the code that calls it are.... ' this code works from a control button.... Private Sub controlbutton1_Click() Call xUnprotect Call UpdatePIT Call xProtect End Sub ' this code does not work from an option button Private Sub OptionButton1_Click() Call xUnprotect Call UpdatePIT Call xProtect End Sub ' these are the protect / unprotect procedures.. Sub xProtect() Application.ScreenUpdating = False Dim xs As Integer For xs = 1 To ActiveWorkbook.Sheets.Count Sheets(xs).Protect Next ActiveWorkbook.Protect Structu=True, Windows:=True End Sub Sub xUnprotect() Application.ScreenUpdating = False Dim xs As Integer For xs = 1 To ActiveWorkbook.Sheets.Count Sheets(xs).Unprotect Next ActiveWorkbook.Unprotect End Sub "Bob Phillips" wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet ActiveX Objects
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting Excel to reference microsoft activex data objects libraryfrom Access | Charts and Charting in Excel | |||
Reference to ActiveX control on worksheet requires full worksheet name | Excel Programming | |||
Excel VBA - ActiveX Data Objects (ado) Performance | Excel Programming | |||
Using activex dll from worksheet | Excel Programming | |||
Missing: Microsoft ActiveX Data Objects Recordset 2.7 Library | Excel Programming |