Hello, all.

I have a protected spreadsheet that uses auto-filter drop downs and a
set of allowed user settings. I needed a macro to unprotect the
sheet, reset all the filter fields, then protect the sheet again. I
was successful in entering code to accomplish all this using
"Auto_Open" and "ActiveSheet.Unprotect Password:="yaddayadda".

However, when the sheet is protected again, the additional allowable
user settings like insert rows, sort, use auto filter, etc. that was
setup in the original sheet are wiped out.

Is there a way to force the allowable user settings within the same
macro? Thank you for your help!