jeffreydbrown
New Member
- Joined
- Apr 25, 2002
- Messages
- 1
is there any way to protect all worksheets within a workbook at one time as opposed to protecting each sheet one at a time?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
worksheet protection
- Thread starter jeffreydbrown
- Start date
Mark O'Brien
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 3,530
using VBA you can protect sheets easily.
<pre>
Public Sub protectsheets()
Dim oSheet As Worksheet
For Each oSheet In Worksheets
oSheet.Protect Password:= ""
Next
End Sub</pre>
This protects them with no password.
<pre>
Public Sub protectsheets()
Dim oSheet As Worksheet
For Each oSheet In Worksheets
oSheet.Protect Password:= ""
Next
End Sub</pre>
This protects them with no password.
Upvote
0
