G
Guest
I need help with approval buttons. I've added 3 command buttons that when
clicked complete a name and date cell indicating the document is approved.
However, the data in those cells can be deleted by any user of the
spreadshet. I want to lock contents of only that cell as part of the command
button action.
Thanks for any help. (Keep in mind i'm a newbie at this)
Using this code to complete the name & date cells...
Private Sub Button2_Click()
End Sub
Private Sub CommandButton1_Click()
Range("A1").Value = Environ("UserName")
Range("B1").Value = Format(Now, "dd mmm yyyy hh:mm:ss")
End Sub
Private Sub CommandButton2_Click()
Range("A2").Value = Environ("UserName")
Range("B2").Value = Format(Now, "dd mmm yyyy hh:mm:ss")
End Sub
Private Sub CommandButton3_Click()
Range("A3").Value = Environ("UserName")
Range("B3").Value = Format(Now, "dd mmm yyyy hh:mm:ss")
End Sub
clicked complete a name and date cell indicating the document is approved.
However, the data in those cells can be deleted by any user of the
spreadshet. I want to lock contents of only that cell as part of the command
button action.
Thanks for any help. (Keep in mind i'm a newbie at this)
Using this code to complete the name & date cells...
Private Sub Button2_Click()
End Sub
Private Sub CommandButton1_Click()
Range("A1").Value = Environ("UserName")
Range("B1").Value = Format(Now, "dd mmm yyyy hh:mm:ss")
End Sub
Private Sub CommandButton2_Click()
Range("A2").Value = Environ("UserName")
Range("B2").Value = Format(Now, "dd mmm yyyy hh:mm:ss")
End Sub
Private Sub CommandButton3_Click()
Range("A3").Value = Environ("UserName")
Range("B3").Value = Format(Now, "dd mmm yyyy hh:mm:ss")
End Sub