Hi everyone,

I am just trying to lock the worksheet so no one can change anything
for all the worksheets.

I have 40 worksheets in a workbook and problem I am having is that I
do know how to lock worksheets by -tools-protection-protect sheet
but it just locks a single worksheet.

Q1. How do I lock all the other worksheet as well instead of clicking
each sheet and repeat what I just did?

Q2. Is it possible for me to set up some kind of 'track changes' and
find out where it is altered and actually who changed it?

Thank you so much for your help

Regards

James