05-12-2019, 11:09 AM
Protect excel sheet with VBA
Code:
Protect the sheet by VBA
Sub UnProtect_Modify_Protect()
ThisWorkbook.Sheets("Costing").Protect Password:="abc123", UserInterfaceOnly:=True
'Unprotect
End Sub
Call UnProtect_Modify_Protect