Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way that I can keep a log of each person that saved a file and the
date and time I use this code below but the area that the information is stored could be changed if discovered...any help would be appreciated Private Sub Workbook_BeforeSave(ByVal SaveAsUI _ As Boolean, Cancel As Boolean) Sheets("Control").Range("V19").End(xlDown).Select a_row = ActiveCell.Row Sheets("Control").Range("V" & a_row + 1).Value = "Last Saved By " & Environ("UserName") Sheets("Control").Range("W" & a_row + 1).Value = Date Sheets("Control").Range("X" & a_row + 1).Value = Time End Sub -- Helping Is always a good thing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 - Open a file with more than one person | Excel Discussion (Misc queries) | |||
How does more that one person edit an excel file on s drive | Excel Discussion (Misc queries) | |||
Windows API to get network username of person with file open | Excel Programming | |||
Create a prompt as a person saves a file | Excel Worksheet Functions | |||
How do I include the name of the last person who saved a Excel do. | Excel Discussion (Misc queries) |