Bryancarlo
New Member
- Joined
- Apr 13, 2021
- Messages
- 21
Hi Team,
Need your help. I have protected my sheets with a password but when I open other excel files, it also locks the sheets or workbook of those files.
Dim wSheet As Worksheet
Dim wb As Workbook
Set wb = Workbooks("Productivity Tool_V13.xlsm")
For Each wSheet In Worksheets
wSheet.Protect Password:="PW", _
UserInterFaceOnly:=True
Next wSheet
Need your help. I have protected my sheets with a password but when I open other excel files, it also locks the sheets or workbook of those files.
Dim wSheet As Worksheet
Dim wb As Workbook
Set wb = Workbooks("Productivity Tool_V13.xlsm")
For Each wSheet In Worksheets
wSheet.Protect Password:="PW", _
UserInterFaceOnly:=True
Next wSheet