You can with a macro,

Sub Protect_All_Sheets()
'will protect all sheets in the workbook
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Protect Password:="123"
Next ws
End Sub

Sub Protect_Selected_Sheets()
'will protect the selected sheets in the workbook
Set MySheets = ActiveWindow.SelectedSheets
For Each ws In MySheets
ws.Select
ws.Protect Password:="123"
Next ws
End Sub

"WORKSHEET PROTECTION" <WORKSHEET
wrote in message ...
How do i password protect multiple spreadsheets within a workbook? I want
to
include several worksheets within a workboook but only allow certain
people
to be able to access certain spreadsheets. How could i do this without
moving
the spreadhseets to their own seperate files?