Macro code to proect and unprotect worksheets
 

Hi,

I have a workbook which can be acces by 10 people. I need to write a
macro which

1. Password protects a specific worksheet. When a user tries to edit
any cell, an input box should appear asking the user to enter the
password. This code will need to work for each worksheet.

2. Upon closing the workbook, the user who unprtected any of the
worksheets needs to be forced to protect them again by entering the
password again.

Is anyone able to provide the relevant code for me?

Thanks,

Nadia