Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect - Unprotect from ActiveX Control
Hi All
I have piece of code that simply unprotects a worksheet, manipulates the sheet contents and re-protects the same sheet. This works fine if run from a workbook module. I then add a ActiveX control button to the sheet, and assign the code to this button through the click-event. I have tried putting the code directly into the event and calling the code from the module but both fail. I rarely use controls on sheets but do recall seeing some references to specfic issues that may be the cause of my difficulties. Can anyone shed any light on this? TIA Cheers Nigel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect - Unprotect from ActiveX Control
Set the TakeFocusOnClick property of the button to FALSE if using XL97.
Or possibly ActiveCell.Select just before the code that is causing the error. "Nigel" wrote in message ... Hi All I have piece of code that simply unprotects a worksheet, manipulates the sheet contents and re-protects the same sheet. This works fine if run from a workbook module. I then add a ActiveX control button to the sheet, and assign the code to this button through the click-event. I have tried putting the code directly into the event and calling the code from the module but both fail. I rarely use controls on sheets but do recall seeing some references to specfic issues that may be the cause of my difficulties. Can anyone shed any light on this? TIA Cheers Nigel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
Protect, unprotect | Excel Discussion (Misc queries) | |||
Protect / unprotect function | Excel Worksheet Functions | |||
Tab to an ActiveX control? | Excel Discussion (Misc queries) | |||
ActiveX control | Excel Programming |