 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008Signatures
I am trying to figure out a way to let users "sign" an spreadsheet for approval. We could accept them typing there initials in a cell, but we need to authenticate that it was that person. Is there any way to do this? Thanks! Get the login id and put it in yourself, they get no option Range("A1").Value = Environ("UserName") Range("B1").Value = Form at(Now, "dd mmm yyyy hh:mm:ss")  SignatureHTH Bob Phillips > I am trying to figure out a way to let users "sign" an spreadsheet for > approval. We could accept them typing there initials in a cell, but we need > to authenticate that it was that person. Is there any way to do this? > Thanks! I am new to macros, how exactly does this work? Thank you! > Get the login id and put it in yourself, they get no option > [quoted text clipped - 6 lines] > > to authenticate that it was that person. Is there any way to do this? > > Thanks! Hi Jasmine, What event would trigger the signing, a change in (a certain) cell(s), closing the workbook, or what? SignatureHTH Bob Phillips > I am new to macros, how exactly does this work? Thank you! > [quoted text clipped - 8 lines] > > > to authenticate that it was that person. Is there any way to do this? > > > Thanks! That works perfectly. I put a button on the page and assigned it to that. Thank you so much for your help!!! > Hi Jasmine, > [quoted text clipped - 13 lines] > > > > to authenticate that it was that person. Is there any way to do this? > > > > Thanks! Hi Jasmine, I was suggesting an automatic way of signing, not needing your user to do anything. SignatureHTH Bob Phillips > That works perfectly. I put a button on the page and assigned it to that. > Thank you so much for your help!!! [quoted text clipped - 16 lines] > > > > > to authenticate that it was that person. Is there any way to do this? > > > > > Thanks! I am trying to make my excel sheet automatically give off the date and time when some data is inputted into the cells next to it. I managed to do this with this code but wanted to add the security that the person signing off is actually authentic. I tried to insert your code into my previous code and it kept giving me "Method "Value" of Object "Range" failed". Do you have any suggestions? Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo EndItAll Application.EnableEvents = False If Target.Cells.Column = 5 Or Target.Cells.Column = 8 Or Target.Cells.Column = 11 Then ActiveSheet.Unprotect Password:="justme" For Each cell In Target If cell.Value <> "" Then With cell.Offset(0, 1) .Value = Now .Locked = True End With End If Next End If EndItAll: Application.EnableEvents = True 'ActiveSheet.Protect Password:="justme" Range("e2").Value = Environ("UserName") End Sub > Hi Jasmine, > [quoted text clipped - 24 lines] > this? > > > > > > Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.