I have a Access 2013 database that exports a report to Excel and then uses VBA to apply formatting inExcel. the process works great unless the user has Excel macros disabled. if Excel macros are disabled it results in a runtime error that I cant seem to capture.
Any thoughts on how to check if Excel Macros are enabled before the formatting process starts? note, all the code is in Access modules.
I don't want to change the setting but I do want to tell the user that they need to.