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!!!