Hi All
I currently have a simple code (below) that creates an electronic signature on a document.
I have a formula in Cell S2 that tells me the row the signature should be on. For example on row 309. how can i incorporate this in to my code so that if someone deletes two rows and now the signature needs to be on row 307. I can make the formula in cell S2 update to 307 but cant think how to add it to the vba to make it dynamic.
Can anyone help and im I just overthinking this
Thanks
Tom
I currently have a simple code (below) that creates an electronic signature on a document.
I have a formula in Cell S2 that tells me the row the signature should be on. For example on row 309. how can i incorporate this in to my code so that if someone deletes two rows and now the signature needs to be on row 307. I can make the formula in cell S2 update to 307 but cant think how to add it to the vba to make it dynamic.
Can anyone help and im I just overthinking this
VBA Code:
Private Sub CommandButton3_Click()
Sheet1.Unprotect ("PASSWORD")
Sheet1.Range("D309").Value = Application.UserName & " - " & Now
Sheet1.Protect ("PASSWORD")
End Sub
Thanks
Tom