Relocking a worksheet

Is there a way to relock a worksheet?
How can I set excel to always require a password to make modifications on a sheet? So, if someone closes the program and forgets to protect the workbook, Excel will automatically do it with the same password?

Re: Relocking a worksheet

Quote from norie

The best way to get the code for that would be to turn on the macro recorder and do the password/protection manually.

I have never used the macro reader, do you have a link to a tutorial for that?

Re: Relocking a worksheet

Or how bout this? Is there a way to allow users to edit cells but not save the file? therefore the file is always locked and will never be changed unless a password is provided?