Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I turn protection on/off with Combo boxes
I am using the "_change()" state of a combo box to make changes in
cell shading and locked status of various ranges. I need to unprotect the worksheet for the changes to be made and protect it afterward. I tried using the "_GotFocus()" and "_LostFocus()" states with ActiveSheet.Protect and ActiveSheet.UnProtect. They work fine but when I close the file I get multiple "runtime 1004" errors for either the cell shading or the locked status. It appears to be an issue with the protection because when I turn off the protection there are no problems. What is the best way to unprotect and protect a worksheet with combo boxes? Thanks, Peter |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I turn protection on/off with Combo boxes
I would break the ListFillRange of the combobox and fill it using code
instead. Probably likewise with the linkedcell property - manage it with code. -- Regards, Tom Ogilvy "P. Graven" wrote in message om... I am using the "_change()" state of a combo box to make changes in cell shading and locked status of various ranges. I need to unprotect the worksheet for the changes to be made and protect it afterward. I tried using the "_GotFocus()" and "_LostFocus()" states with ActiveSheet.Protect and ActiveSheet.UnProtect. They work fine but when I close the file I get multiple "runtime 1004" errors for either the cell shading or the locked status. It appears to be an issue with the protection because when I turn off the protection there are no problems. What is the best way to unprotect and protect a worksheet with combo boxes? Thanks, Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
Selecting subsets using combo boxes or list boxes | Excel Discussion (Misc queries) | |||
Questions on combo boxes and list boxes. | New Users to Excel | |||
Combo boxes and Protection | Excel Discussion (Misc queries) | |||
List boxes/combo boxes | Excel Programming |