Protect sheets with macro

[SpritHansi]

Hi!
I use this macro to protect all sheets in my workbook

Please Login or Register  to view this content.

And this macro to unprotect the sheets

Please Login or Register  to view this content.

I want to open some of the sheets to allow "edit objects"
Can someone help me please :-)

[royUK]

Use the macro recorder to get the code. Then post back if you need help adapting it to your existing macros

[SpritHansi]

I've done that, and got this code

Please Login or Register  to view this content.

But it didn't record the password i entered. How do I add this to the code?

[Leith Ross]

Hello SpritHansi,

Here is your macro with the password added. It is marked in bold text. Change it what you want.

Please Login or Register  to view this content.