You might want to try something like this:
But this will protect/unprotect all sheets at once:
"Cas" wrote in message
I have a workbook consisting of 14 worksheets. This requires users to
data in various cells but I dont wish them to have access to all cells.
Therefore I use Excels "Protect sheet...." feature to prevent users
modifying formulas etc. The workbook periodically has to be changed and
means individually unprotecting each worksheet and then re-protecting
Is there a way to select all 14 sheets and then protect/unprotect in one
This would save me a great deal of hassel (entering the password 28
so any solution would be very welcome.