When working with the Excel version of the drawing list, you will constantly be asked if you want to enable macros when using the macro to export the list for a client. To have Excel automatically enable macros you will need to follow these simple steps.
Click the Office Application Menu and select EXCEL OPTIONS.
Click TRUST CENTER from the list on the left then click the TRUST CENTER SETTINGS button.
Click MACRO SETTINGS then select the option to ENABLE ALL MACROS. Click OK to close all dialog boxes.
And that’s all there is to it.