Excel 2007 : Password protection

[loveorhate776]

I am working on an excel file for someone else. I need to password protect some of the sheets with the password they selected. is there a way to make it automatically password protect if they need to un-protect then re-protect? this would mean they couldn't put in a different password on that sheet.

Thanks!

[DGagnon]

you could create a macro for protect and use a button, else they will need to type the password to enable protection. macro would look something like this:

Please Login or Register  to view this content.

[royUK]

Try this

Please Login or Register  to view this content.