Hi All

I'm using a macro to protect a selection of cells within multiple identical work sheets.

I noticed only the original sheet that the macro is recorded on is protect with the actual password, the other sheets are protect but no password is needed to unprotect them.

Is there away round this? what am i doing wrong?

P.s. i'm a newb this is the first macro i have ever run

Any thoughts appreciated

Thanks