Reprotect after macro exits.

Thanks to the wonderful help of everyone on the forum, I've almost finished my project; however, I have one last bit of code I can't figure out.

Please Login or Register  to view this content.

The code unprotects the sheets to run the macro properly (to avoid a nasty GoTo error). It also reprotects the sheets after the macro has run its course...except, if the user selects "No" the sub ends without reprotecting the sheet. This is my last bit of code & any help is greatly appreciated!

By the way, the Open Event has a UserInterfaceOnly protection for the entire workbook. (See note below for reference)

By the way, much thanks to Forum Moderator shg. Without his patience and assistance, I never would have gotten this far (I probably would have thrown in the towel!)

I have attached my somewhat lame project for all to try to understand.

How 'bout

Please Login or Register  to view this content.

You are a genius! However, one problems builds another. But 1 modification (I can be taught) and it's PERFECT!

Please Login or Register  to view this content.

Note my need to apply the protection again before the last end if. It wasn't reprotecting the very first sheet it searched. THANK YOU!

Very nice. That's my solution. Thank you again. I couldn't have done it without your help. I just hope that I can help someone on here someday with the knowledge I'm gathering from just perusing the forum.