Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Protect excel sheet with VBA
#1
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
Reply
#1
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
Reply
CAA


Forum Jump:


Users browsing this thread: 1 Guest(s)