Write, Bureaucrats, Administrators
1,991
edits
Difference between revisions of "When Publishing Visual Basic for Applications editor opens"
Jump to navigation
Jump to search
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'''. | ||