Macro Code to individually password protect a sheet

Hi Zane, welcome to the forum
Well, I don't know where you are looking but Google offers enough solutions.
The simplest is record your own macro.
Start the macro recorder and password protect one worksheet, make sure you select the things you still want allowed like Autofilter and select unprotected as well as protected cells
Stop the macro recorder an look at the code.
You can then copy this code and apply it to other sheets with another password.
Keep in mind that you must remember them to unprotect the worksheets.

If you're stuck, just holler and explain a little more what you want to do
Happy coding

What do you mean by this ?

all sheets with an individual password

Is it every sheet with a different password or all sheets with 1 password.
If it's the first you need to create an array of passwords equal to the number of sheets and loop through the array and sheets.
Or you can come up with some sort of algorithm to create a unique password for every sheet.
In the second case it's just a matter of looping through sheets and assigning the samme password every time.

This is how it works.
Make an extra start sheet where you can redirect when wrong password.
Put below code in sheetmodule of all to be protected sheets.
Amend password and return sheetname.

Please Login or Register  to view this content.