Cell Specific authentication

Question

Hello,

I am trying to find a way to create cell specific time stamps and cell specific user verification in excel. We use excel in a way that requires user signoffs and time stamps. Is this something that can be done?

Answer 1

Something like this:

1. Copy this code.
2. Right-Click the sheet tab of interest.3) Select "View Code"4) Paste the code into the window that appears.5) Save the file as a macro-enabled .xlsm file.6) Make changes as needed Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count > 1 Then Exit Sub If Target.Column <> 3 Then Exit Sub 'only check cells in column C If Application.UserName <> "Ramirez, Pierson" Then 'only you can can make the change in column C

    'Turn off events to keep out of loops 
   
    Application.EnableEvents = False 
   
    Application.Undo 
   
    MsgBox "You """ & Application.UserName & """ don't have permission to change that cell." 
   
    'Turn events back on to get ready for the next change 
   
    Application.EnableEvents = True 
   
    Exit Sub 
   

   End If 'Turn off events to keep out of loops Application.EnableEvents = False Target.Offset(0, 1).Value = Application.UserName & " " & Now 'Turn events back on to get ready for the next change Application.EnableEvents = True

End Sub

Answer 2

Thanks, what would that coding look like?

Answer 3

If you are using desktop Excel, then you can use VBA/event code to do user verification and create time stamps.