Hi, Please help.
I've been working on this audit trail / log for MS Excel. I downloaded the spreadsheet from the following link: http://excelexperts.com/VBA-Tips-Log-An-Audit-Trail
Whenever, I do any format or anything unrelated to simply typing in data in a cell in Sheet 1, I get a debug error.
Is there a way to add code to the current code to ignore formatting and use of other code such as the date picker to avoid the debug issue?
I've attached my working spreadsheet. The Desc tab also contains a description of this issue, which is Issue 2 -- the focus of this thread. I will post the remaining issues 3-11 separately.
Thank you in advance for your assistance!