Require your help and time for an project currently working on , but could not find out the solution, The work sheet already has an Macro with it for protection.
Sub Locksheet()
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, Password:="Partha"
ActivaSheet.EnableSelection = xlUnlockedCells
End Sub
Sub unlocksheet()
ActiveSheet.Unprotect Password:="Partha"
End Sub
need another with a time stamp at G4 cell when the "SUBMIT REPORT" is clicked , I have 31 sheets in the workbook each for a day of the month.
Bookmarks