Click here to Skip to main content
15,844,009 members
Please Sign up or sign in to vote.
3.00/5 (2 votes)
See more:
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!!!


1 solution

Share this answer
H.Brydon 28-Jul-13 0:50am    
Great answer (+5). Yeah its me again...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900