I have say 10 sheets in the workbook
and I have created a table listing all 10 names of the respective worksheet in column A and each password for each of the respective sheets in column B.
I need the macro to protect each of the sheets based on the password i have listed in the table respectively.
I kept getting object failed error with the codes i have written below.
Please help.
Please Login or Register to view this content.
Bookmarks