View source for When Publishing Visual Basic for Applications editor opens

==Overview==

When [[Publishing Reports|publishing reports]], the [[Visual Basic for Applications Editor|Visual Basic for Applications editor]] may open which will prevent the publish process from completing.

To prevent this from happening follow the steps below.

==Procedure==
[[File:TrustCentre.png|300px|thumb|right|Trust access to the VBA object model]]

#[[Close BudgetLink]]
#'''Start''' Excel;
#Go '''File \ Options''';
#Click on '''Trust Centre''';
#Click on '''Trust Centre Settings button''';
#Go to '''Macro Settings''';
#Tick the '''Trust access to the VBA object model''';
#Click '''Ok/Close''' all dialogue and excel;
#Start BudgetLink;
#Try [[Publish|Publishing]] again. It should succeed this time;