Unless you are running Excel 24/7, the only way is to open the workbook whose worksheets you want to protect and then run this macro:
Dim ws As Excel.Worksheet
For Each ws In Worksheets
Of course you would substitute your real password for "password1".
Last Wiki Answer Submitted: April 8, 2008 12:02 pm by JP2112475 pts.