Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Audit Trail
I would like to build an audit trail into a spreadsheet so that anyone who
opens the file is is logged in a worksheet with user name and time stamp. What's the easiest / best way to achieve this? -- Rich http://www.rhodes-pefkos.co.uk http://www.rhodes-lindos.co.uk |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Audit Trail
Look into Track Changes in the Excel Help.
Or, for a VBA method; http://www.ozgrid.com/VBA/track-changes.htm -- Regards Dave Hawley www.ozgrid.com "Rich" wrote in message ... I would like to build an audit trail into a spreadsheet so that anyone who opens the file is is logged in a worksheet with user name and time stamp. What's the easiest / best way to achieve this? -- Rich http://www.rhodes-pefkos.co.uk http://www.rhodes-lindos.co.uk |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Audit Trail
Rich,
Alt+F11 to open VB editor. Double click 'ThisWorkbook' and paste the code below in on the right. It uses a worksheet called "Audit" Private Sub Workbook_Open() Dim LastRow As Long Set sht = Sheets("Audit") LastRow = sht.Cells(Cells.Rows.Count, "A").End(xlUp).Row + 1 sht.Cells(LastRow, 1) = Environ("Username") sht.Cells(LastRow, 2) = Now End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Rich" wrote: I would like to build an audit trail into a spreadsheet so that anyone who opens the file is is logged in a worksheet with user name and time stamp. What's the easiest / best way to achieve this? -- Rich http://www.rhodes-pefkos.co.uk http://www.rhodes-lindos.co.uk . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Audit Trail
Hi,
In case the user doesn't save it may be a good idea to save it with the openers username by making this the last line in the code ActiveWorkbook.Save -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Mike H" wrote: Rich, Alt+F11 to open VB editor. Double click 'ThisWorkbook' and paste the code below in on the right. It uses a worksheet called "Audit" Private Sub Workbook_Open() Dim LastRow As Long Set sht = Sheets("Audit") LastRow = sht.Cells(Cells.Rows.Count, "A").End(xlUp).Row + 1 sht.Cells(LastRow, 1) = Environ("Username") sht.Cells(LastRow, 2) = Now End Sub -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Rich" wrote: I would like to build an audit trail into a spreadsheet so that anyone who opens the file is is logged in a worksheet with user name and time stamp. What's the easiest / best way to achieve this? -- Rich http://www.rhodes-pefkos.co.uk http://www.rhodes-lindos.co.uk . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Audit Trail
See http://www.cpearson.com/Excel/Tracki...bookOpens.aspx . Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Sat, 10 Apr 2010 09:42:09 +0100, "Rich" wrote: I would like to build an audit trail into a spreadsheet so that anyone who opens the file is is logged in a worksheet with user name and time stamp. What's the easiest / best way to achieve this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Leading zero's trail Number | Excel Worksheet Functions | |||
Excel 2007 'Trail" | Excel Discussion (Misc queries) | |||
audit trail | Excel Discussion (Misc queries) | |||
Audit Trail | Excel Discussion (Misc queries) | |||
excel trail balance worksheet | Excel Discussion (Misc queries) |