Is there some event in the libraries that can detect when the user who is working on the excel file, has run a macro?
For example, the user opens an excel document which contains an macro, than he runs the macro and the .net application, that is attached to that excel process detect the start macro event?
or maybe bind the macro function to a delegated event in the application..
Can the 'Run Macro' CommandBarControl click event be caught from the code behind?
Thank you for posting in the MSDN Forum.
It based on my experience that there's no such an event to directly detect whether a macro has run. Nor could you catch the 'Run Macro' CommandBarControl click event.
I think you'll need to find other ways for your request.
Hope it helps.
Quist Zhang [MSFT]
MSDN Community Support | Feedback to us
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?