Is there a way to protect all of the worksheets at once. When I use the
workbook protection it doesn't do what I need.

It seems the only way I can protect specific cells is to use the sheet
protection and this means one sheet at a time.

Is there anyway to get all of the sheets protected at one time??

Jeannine Wrote:
Is there a way to protect all of the worksheets at once. When I use
the
workbook protection it doesn't do what I need.

It seems the only way I can protect specific cells is to use the sheet
protection and this means one sheet at a time.

Is there anyway to get all of the sheets protected at one time??

Try using this macro. You can stick it in your Personal.xls, then just
run it whenever you want.

Public Sub ProtectAllSheets()
Dim aWorksheet As Worksheet

For Each aWorksheet In Worksheets
aWorksheet.Protect "YourPassword"
Next aWorksheet

End Sub

If you want, you can add code to prompt you for the password. You can
also set it up so that you can choose when running it whether you want
to protect or unprotect all sheets.

Scott


--
Maistrye
------------------------------------------------------------------------
Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078
View this thread: http://www.excelforum.com/showthread...hreadid=563381