You have to use VBA for this. This example willl assign the same password to
each sheet.
I'm running 2003, and this works for me.
If you are unfamiliar with macors, see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Sub ProtectAllSheets()
Dim sht As Worksheet
For Each sht In ThisWorkbook.Worksheets
sht.Protect "password"
Next sht
End Sub
tj
"Adam" wrote:
Hi
I'm using Excel 97 and get a bit annoyed having to Protect each worksheet
individually.
Is there a way where I can password protect all sheets in a workbook?
Please advise
--
Adam
-----------
Windows 98 + Office Pro 97