One way:

http://www.mcgimpsey.com/excel/subs/...orksheets.html

In article ,
"ME" wrote:

HOW DO I PROTECT MULTIPLE WORKSHEETS IN A WORKBOOK ALL AT THE SAME TIME?