VBA Auto Protect
How can I make the worksheets in Excel automaticaly protected on date
Software/Hardware used:
Software/Hardware used:
ASKED:
April 7, 2008 10:21 AM
UPDATED:
April 8, 2008 12:02 PM
Answer Wiki:
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:
<pre>Sub ProtectMe()
Dim ws As Excel.Worksheet
For Each ws In Worksheets
ws.Protect Password:="password1"
Next ws
End Sub</pre>
Of course you would substitute your real password for "password1".
HTH,
JP
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
