When I select all of the worksheets the option to password protect goes away. Is there a code? Thank you!
Try this macro. Change the password to suit, or eliminate if desired.
Open the workbook.
Copy this macro to the clipboard:
Sub Protect_All_Sheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Protect Password:="Your word"
Next ws
End Sub
Select the appropriate worksheet and right click on the sheet tab.
Click ‘View Code’.
Paste the macro into th module area to the right.
Close back to Excel.
Go to Tools > Macros > Macro
Highlight this macro, if it is not already highlighted.
Click ‘Options’
Select a letter to be used as a keyboard shortcut.
Close back to Excel.
Press Ctrl + your letter to protect all sheets.
To unprotect all sheets in the same manner, use this macro and assign a different keyboard shortcut letter.
Sub Unprotect_All_Sheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Unprotect Password:="Your word"
Next ws
End Sub