I am trying to log the opening and closing of excel workbooks to replace the Journaling capability in office.
I have created and tested VBA auto_open and auto_close macros in excel, which log these events to a file. I have then copied them to PERSONAL.xlsb. They run successfully when PERSONAL.xlsb is opened or closed. They have no effect when opening or closing any other workbook.
Am I missing something simple, or is this approach doomed to failure?