Password protection in Excel

[calmo]

Is it possible to password protect several worksheets in one step, or do I
need to them all individually?

[JE McGimpsey]

You could use a macro:

Public Sub ProtectAll()
Const PWORD As String = "drowssap"
Dim wsSheet As Worksheet
For Each wsSheet In ActiveWorkbook.Worksheets
wsSheet.Protect PWORD
Next wsSheet
End Sub

In article <2889E9F7-5994-434E-BCF2-8304E2FEB4EB@microsoft.com>,
"calmo" <calmo@discussions.microsoft.com> wrote:

> Is it possible to password protect several worksheets in one step, or do I
> need to them all individually?