Need to control running of Macro during openning of Workbook

See more:

C#

COM

MS-Excel

VBA

Hello All,

We have a custom com add-in for excel. We are overriding the workbook_open event of excel to de-serialize our custom data which is stored in the activeX control. But, if a workbook contains a macro, while opening the workbook it first runs the macro after that it calls our methods in the Workbook_open() function. This behavior we observed in both Excel 2007 and Excel 2010.

We want to display the security warning to the user if a workbook contains macro as per excel behavior and if user allows macro to run then only we want to de-serialize our data.

Please share something on this issue, if anybody faced same kind of issue.

Thanks in Advance!!!

Regards,
Vieer