Difference between revisions of "Enabling Macros in Microsoft Excel"

Enabling Macros in Microsoft Excel (view source)

797 bytes added , 2 October

Added steps to enable macros in Excel 365

89

edits

@@ Line 2: / Line 2: @@
 BudgetLink requires macros to be enabled in order to run correctly.
+== How to Enable Macros in Excel 365 ==
+[[File:enable_macros.png|300px|thumb|right|Trust Center - Macro Settings]]
+When you first open BudgetLink in Microsoft Excel, you will typically receive the following security warning. This is a security feature of Microsoft Excel which is there to ensure you only run trusted code.
+# When you receive the '''Security Warning''', click on '''File''' > '''Options'''
+# An '''Excel Options''' dialog box will be displayed
+# Click on '''Trust Center''' tab in the left side panel and click on '''Trust Center Settings'''
+# Another dialog box '''Trust Center''' will open.
+# Click on '''Macro Settings''' in the left panel
+# Select "Enable VBA macros..." redio button, and "Enable Excel 4.0 macros..." checkbox.
+# Click on OK to close both the dialog boxes.
 == How to Enable Macros in Excel 2007, 2010 and 2013 ==