P
P. Graven
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
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