Write, Bureaucrats, Administrators
89
edits
Difference between revisions of "Enabling Macros in Microsoft Excel"
m
changed formatting of images, layout
m (spelling fix redio -> radio) |
m (changed formatting of images, layout) |
||
| Line 1: | Line 1: | ||
[[File:enable_macros_security_warning.png|300px|thumb|right|Enable Macros - Security Warning]] | |||
[[File:enable_macros.png|300px|thumb|right|Trust Center - Macro Settings]] | |||
== Overview == | == Overview == | ||
BudgetLink requires macros to be enabled in order to run correctly. | BudgetLink requires macros to be enabled in order to run correctly. | ||
To avoid enabling Macros on each startup, you can [[Adding a Trusted Location in Microsoft Excel | add your installation folder as a Trusted Location]] | |||
== How to Enable Macros in Excel 365 == | == How to Enable Macros in Excel 365 == | ||
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 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. | ||
[[File:StartupSecurityWarningExcel2007.png|300px|thumb|right|Security Warning - Older version]] | |||
[[File:AddTrustedPublisherExcel2007.png|300px|thumb|right|Security Alert - Macros]] | |||
# When you receive the '''Security Warning''', click on '''File''' > '''Options''' | # When you receive the '''Security Warning''', click on '''File''' > '''Options''' | ||
# An '''Excel Options''' dialog box will be displayed | # An '''Excel Options''' dialog box will be displayed | ||
| Line 19: | Line 20: | ||
# Select "Enable VBA macros..." radio button, and "Enable Excel 4.0 macros..." checkbox. | # Select "Enable VBA macros..." radio button, and "Enable Excel 4.0 macros..." checkbox. | ||
# Click on OK to close both the dialog boxes. | # Click on OK to close both the dialog boxes. | ||
== How to Enable Macros in Excel 2007, 2010 and 2013 == | == How to Enable Macros in Excel 2007, 2010 and 2013 == | ||
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 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. | ||