Select Specified Sheets, Not all sheets - Need your help!

Hi VBA experts,

I found this code online to protect/unprotect worksheets in my workbook. It seems to work fine only if you want your password protected sheets to unprotect and your unprotected sheets to get protected. What is the proper code to select specific sheets to protect/unprotect rather than all sheets in an entire workbook?

Thank you in advance for your help!

Please Login or Register  to view this content.

use

Please Login or Register  to view this content.

rename Sheet1 and Sheet2 and Sheet3 with the sheets you want to exclude from being passw protected

Thank you for the reply but I am getting an error when I try to run this code. Can you please let me know what I am doing wrong?

Please Login or Register  to view this content.

dont use quotation marks or commas -use the code EXACTLY as i posted it.

That worked!!!

Thank you!

happy to help. mark this thread as "solved" if you are satisfied with it.