Write, Bureaucrats, Administrators
2,725
edits
Difference between revisions of "Trusting access to the VBA project model"
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 == | ||