I have a workbook with about 15 worksheets in it.

I want everyone to be able to look at this without being able to change it,
and one person to be able to change it.

I dont want to go down the "open read-only unless you have a password"
route, as this still means that everyone can change the data, even if they
cannot save it.

However, if I go down the "protect sheet" route, then the 1 person who is
allowed to change the data will have 15 sheets to unprotect and then
reprotect each time he goes in and changes something.

Is there any other way of achieving what I want?

Thanks,

Will