WebADI Run-time error'1004' Method 'VBProject' of object '_Workbook' failed

Error

WebADI Run-time error'1004' Method 'VBProject' of object '_Workbook' failed

Root Cause of the Error

MS Excel not enabled for trusted access to VBA Project Object Model

How to reproduce the error?

1. Navigate to General Ledger responsibility > Journals > Launch Journal Wizard

2. Select the Layout = 'Functional Actuals Single' and Content = 'None', and hit button 'Create Document'

3. WebADI Excel spreadsheet will be downloaded on your desktop

4. Open the file and error appears

Solution

For MS Excel 2010:
1. Go to File > Options > Trust Center

2. Bit the button 'Trust Center Settings'

3. Click the checkbox 'Trust access to VBA project object model' 

4. Now retry opening the WebADI spreadsheet and the error will not appear.

Environment

Oracle E Business Suite R12.1.3+

OS - Oracle Linux

User Management responsibility gives errors
Web ADI Configuration Error - BNE_UIX_PHYSICAL_DIR...