How do I turn protection on/off with Combo boxes

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
 
T

Tom Ogilvy

I would break the ListFillRange of the combobox and fill it using code
instead. Probably likewise with the linkedcell property - manage it with
code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top