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

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