Write, Bureaucrats, Administrators
2,725
edits
Difference between revisions of "Trusting access to the VBA project model"
Jump to navigation
Jump to search
Trusting access to the VBA project model (view source)
Revision as of 17:44, 23 February 2015
, 17:44, 23 February 2015no edit summary
(Created page with "== Overview == Compile errors can occur during publish as some worksheets contains code. The publishing process can remove this code but only if the option to '''trust acces...") |
|||
| Line 4: | Line 4: | ||
== Trusting access to the VBA project model in Excel 2013 == | == Trusting access to the VBA project model in Excel 2013 == | ||
[[File:TrustVBAExcel2013.png|300px|thumb|right|Trust access to the VBA project model in Excel 2013]] | |||
To trust access to the VBA project model in Excel 2013, follow these steps. | |||
# Start Excel; | |||
# Click on the '''File''' button and select '''Options'''; | |||
# Select '''Trust Center''' in the list on the left-hand side; | |||
# Click the '''Trust Center Settings''' button; | |||
# Select '''Macro Settings''' in the list on the left-hand side; | |||
# Tick the '''Trust Access to the VBA project object mode'''; | |||
# Click '''OK''' and close on all dialogues; | |||
# Close Excel; | |||
# Start and use BudgetLink. | |||
<br clear=all /> | |||
== Trusting access to the VBA project model in Excel 2010 == | |||
[[File:TrustVBAExcel2010.png|300px|thumb|right|Trust access to the VBA project model in Excel 2010]] | |||
To trust access to the VBA project model in Excel 2013, follow these steps. | To trust access to the VBA project model in Excel 2013, follow these steps. | ||
| Line 16: | Line 36: | ||
# Close Excel; | # Close Excel; | ||
# Start and use BudgetLink. | # Start and use BudgetLink. | ||
<br clear=all /> | |||
== Trusting access to the VBA project model in Excel 2007 == | |||
[[File:TrustVBAExcel2007.png|300px|thumb|right|Trust access to the VBA project model in Excel 2007 ]] | |||
To trust access to the VBA project model in Excel 2007 , follow these steps. | |||
# Start Excel; | |||
# Click on the '''Office''' button and select '''Excel Options'''; | |||
# Select '''Trust Center''' in the list on the left-hand side; | |||
# Click the '''Trust Center Settings''' button; | |||
# Select '''Macro Settings''' in the list on the left-hand side; | |||
# Tick the '''Trust Access to the VBA project object mode'''; | |||
# Click '''OK''' and close on all dialogues; | |||
# Close Excel; | |||
# Start and use BudgetLink. | |||
<br clear=all /> | |||
== Related Topics == | == Related Topics == | ||