Wednesday, May 19, 2010

Enable Macro in Excel 2007 for "Export to Excel" functions

Excel 2007 doesn't automatically pop up a window asking user to enable macros. Instead, it silently displays a security warning message right below the tool bar (see the snapshotshot). If you don't notice it, ADEPT may appear to be doing nothing when you run any "Export to Excel" function. You will need to click the "Options..." button in the warning message and a window will pop up for you to enable the macro. Select "Enable this content" and then click OK. The exported spreadsheet will then be generated.

No comments:

Post a Comment