Control ComboBoxes & Worksheet Protection

[ChrisF]

Hi,

I have been creating a user form whereby the user selects a record from
a combo box. Once they have made a selection I have a macro that
highlights cells on the same worksheet. The worksheet is protected, so
I would like, via use of the OnChange Event(or something else) for the
worksheet to unprotect, change the highlighted cells, then reprotect
leaving the user with no access to the sheet other than to view it.

I have tried an array of Macros none seem to work. They work on a sheet
where the combobox is missing, i think this could be the problem, but
can not find away around it.

Any ideas?

Many Thanks

 

[Cliff Myers]

If you are using a form, then add this to the top of your command button
click_event code.
Sheetname.Unprotect "password"
the rest of your code
then at the end add:
Sheetname.Protect "password"
HTH