Nothing built into excel.

But you could create a macro:

Option Explicit
Sub ProtectThemAll
dim myPwd as string
dim wks as worksheet
myPwd = "hi there"

for each wks in activeworkbook.worksheets
wks.protect password:=mypwd
next wks
end sub
Sub UnProtectThemAll
dim myPwd as string
dim wks as worksheet
myPwd = "hi there"

for each wks in activeworkbook.worksheets
wks.unprotect password:=mypwd
next wks
end sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Pistols14 wrote:

Is there any way to protect all the worksheets in a workbook without having
to go to each individual worksheet and using Tools Protection Protect
Worksheet?

--

Dave Peterson