unprotect sheet code then reprotect

[ryan_law2000]

I have a userform that will input information into protect cells.

I need a code that will unprotect the sheet
run the code i curently have
then reprotect the sheet.

i currently do not have a password set but if needed for the code lets just go with
"password"

Thank you!

 

[Smitty]

You could have gotten everything but the password from the recorder.

Sheets("Sheet1").Unprotect "password"
'  your code
Sheets("Sheet1").Protect "password"

HTH