Excel, Save As OpenText message displays "Cannot run the macro 'DMFooter.BeforeDMSaveAs'. THe macro may not be available in this workbook or all macros maybe disabled"

[dd]

Description:
1. From the application Microsoft Access an Excel file is generated
2. press Save - the is result Native Excel Save dialog displays (no DM
integration)
3. Press Save As - the result is:
OpenText message displays "Cannot run the macro
'DMFooter.BeforeDMSaveAs'. THe macro may not be available in this
workbook or all macros maybe disabled"
4. THe DM profile screen displays, enter data click OK
5. OpenText message displays "Cannot run the macro
'DMFooter.AfterDMSaveAs'. THe macro may not be available in this
workbook or all macros may be disabled.
6. In DM the excel file is checked out. The users have to close DM,
reopen DM, the check-in dialog box displays, check in the excel file
and continue working.


Tests:
1. disabled our custom code add-in - result error messages still
disabled
2. If I open DM, within DM double click to open excel, create a new
spreadshet and press either Save or Save As, - the result is correct
behaviour with the DM profile screen displays. no macro error messages
displayed
3. If I open another application CMS, export and generate an excel
file. press Save As the result is the same as Microsoft Access
Save - the result is Native Excel Save dialog displays (no DM
integration)
Save As - the result is OpenText message displays "Cannot run the
macro message", DM profile screen displays,e nter data click OK.

Summary: the error appears to occur when other systems/databases link
to excel, a Save or Save As is performed results in no dm integration

Other:
The following registry items exist on the local pcs
[HKEY_CURRENT_USER\Software\Hummingbird\PowerDOCS\AppIntegration\Excel
\Options]
"EventAfterDMSaveAs"="DMFooter.AfterDMSaveAs"
"SHOW_OPTIONS_DIALOG"=dword:00000001
"EventBeforeDMSaveAs"="DMFooter.BeforeDMSaveAs"


In Excel, Trust Center settings, Macro Settings is set to "Enable all
macros"


The workaround provided to the users for now is:
1.Excel file is generated.
2.Perform a Save, the Microsoft Excel native Save dialog displays.
save to the network. close the excel file.
3. Import the excel file into DM.



Environment:
Office 2007 SP2
Company templates and vb.net custom add-in for Microsoft Office
DM 52.5

Question:
are there other registry keys to be set? or for me to check
note: this use to function correctly. in Production this no longer
works.

many thanks