Auto Lock multiple sheets used range

[gleamng]

Good day everyone
i need help to automatically lock multiple sheets used range
i have a workbook with sheets with similar names generated from same template
the each sheets have many formula which i have locked and passwordded the sheets
what i want is anytime i make input in any sheet it should lock the entry i made in sheet after i switch to another sheet
Thank you for your help. Wishing us all a prosperous New Year

 

[mumps]

Look into the "Worksheet_Deactivate" event. This type of macro will run automatically when you switch to another sheet.

 

[gleamng]

Thanks for your response, i dont know how to go about it, kindly help me out please

 

[mumps]

In order to lock a sheet, it needs to be protected. The problem is that once it is protected and locked, you have to unprotect it make any changes to the sheet. Do you plan to unprotect it manually when you want to make changes? Also, are there any sheets that do not need to be locked? If so, what are their names?