audit trail

Hi everybody, I've tried a bunch of different codes I've found online for creating an audit log that tracks any changes within a workbook but either they do not work, or they create an endless loop that eventually crashes Excel. Can anyone help me with some code that will track any changes made...

Hi, I'm trying to keep track of who opens an excel workbook and the date. I have some code here to identify the user: Public Function UserName() UserName = Environ$("UserName") End Function This is a good start but a single cell is not a good solution because I would always just see me as...

So i have a lot of password protected macro buttons in my project and I am tracking the user name of anyone who enters the correct password on a hidden sheet called "users" its kind of a built in audit trail . I would also like to capture the user names of people who enter a bad password...

Hi MrExcel Community, It's my first post here - so "Hello" :-) Currently I'm using this Audit Trail Macro to track cell changes in multiple sheets: Option Explicit Dim sOldAddress As String Dim vOldValue As Variant Dim sOldFormula As String Private Sub Workbook_TrackChange(Cancel As...

I only recently started learning how to use VBA code and I'm come to a standstill with one particular code. I'm not too sure where to start and hope someone here is a miracle worker and can help me! What I'm aiming to achieve: A hidden, and preferably locked, worksheet that will record...

My end users enter data in the sheet for a batch, then they press a button to run code, check for certain errors, then lock the cells. Audit trail is populated with Date, Time, Excel User ID, Batch Number, worksheet tab. Sub AuditTrail(batchnumber As String)...

Hi, I’m having issues with tracking changes within Excel. I have been able to set up the track changes options but I seem to lose my setting when emailing or uploading the document to Sharepoint 2013. I’d like to create an approvals worksheet, the idea is people would enter their name beside...

Hello, Setup: I use the two macros below to log changes (i.e. keep an audit trail) in a worksheet (using Excel's "Track changes" tool forces me to share the workbook...and sharing comes with loads of limitation...). Issue: It works great except for one thing: if I paste new data over a range a...