G
Guest
I am trying to protect particular sheets in a workbook.
Code used:
Private Sub Workbook_Open()
Password = "1234"
Sheets("MasterData").Protect Password, True, True, True
Sheets("Unassigned Requests").Protect Password, True, True, True
End sub
And i unprotect using
Sheets("Unassigned Requests").Unprotect Password
This protects my entire workbook when i open it the next time. How to avoid
this?
Code used:
Private Sub Workbook_Open()
Password = "1234"
Sheets("MasterData").Protect Password, True, True, True
Sheets("Unassigned Requests").Protect Password, True, True, True
End sub
And i unprotect using
Sheets("Unassigned Requests").Unprotect Password
This protects my entire workbook when i open it the next time. How to avoid
this?