sheetslogdetails.rangea

I am newbie to VBA/Macro. Is it possible to run 2 different macros in one workbook? I have 2 macros that do different functions on my spreadsheet. The first one is for Auto lock the cells after entry. The second macro is for Audit trail. If i run both separately on separate spreadsheet, works...

Hi Everyone I need your help how can I automatically track changes in excel in a specific worksheet and cell range only using vba. I used the code below but the code seems to work globally it track changes in all worksheet. I hope someone will help me to have a workaround in this code. Any help...

I have this Macro that tracks any changes made to the "Data" sheet onto the "LogDetails" sheet...I want to it to only track changes made if those changes fall within a range (A9:M80). Here is the Macro I have: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim...

Good afternoon all, I am working on a pretty big workbook for which a logbook is automatically filled whenever a cell content is changed in any worksheet. It works quite well but I have an issue when the content of multiple selected cells is deleted. A run-time error '13' type mismatch appears...

I have this code that records the change, its date and the user that did it for all sheets on another sheet, what i need is only the changes in column "N" in a sheet named "Input" to be recorded, below is the code: Private Sub Workbook_Open() Sheets("LogDetails").Visible = True End Sub...