What are the macro security settings that I need to have in Excel to submit my report electronically?

See Enabling Macros in Excel for information on what macro settings need to be enabled and how to set them. Many of the features of the program will not operate correctly without macros enabled.