Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |