Write, Bureaucrats, Administrators
1,991
edits
Difference between revisions of "When Publishing Visual Basic for Applications editor opens"
When Publishing Visual Basic for Applications editor opens (view source)
Revision as of 20:32, 15 June 2016
, 20:32, 15 June 2016→Procedure
(Created page with "==Overview== When the Visual Basic for Applications editor opens when you publish the report. Follow the below steps to resolve this issue. ==Procedure== [[File:TrustCentre...") |
|||
| Line 8: | Line 8: | ||
[[File:TrustCentre.png|300px|thumb|right|Trust access to the VBA object model]] | [[File:TrustCentre.png|300px|thumb|right|Trust access to the VBA object model]] | ||
#Start Excel; | #'''Start''' Excel; | ||
#Go File \ Options; | #Go '''File \ Options'''; | ||
#Click on Trust Centre; | #Click on '''Trust Centre'''; | ||
#Click on Trust Centre Settings button; | #Click on '''Trust Centre Settings button'''; | ||
#Go to Macro Settings; | #Go to '''Macro Settings'''; | ||
#Tick the | #Tick the '''Trust access to tbe VBA object model'''; | ||
#Click | #Click '''Ok/Close''' all dialogue and excel; | ||
#Run BudgetLink; | #Run BudgetLink; | ||
Done. | '''Done'''. | ||