audit logs

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...

In which sheet(s) Column A does a string from the Active.Sheet, Column, A appear in the workbook? Need source string and names of the sheets. Rows or column result ok dumped into a target sheet; it doesn't need to be pretty. I need something to work with applying my current skills. Of...

Hello, I'm currently using this code to keep a log of changes to a workbook. Dim PreviousValue As VariantPrivate Sub Worksheet_Change(ByVal Target As Range) Dim Errb As Integer On Error GoTo ErrTrap: If Target.Value <> PreviousValue Then With Sheets("log").Cells(65000...