Enable Events option in Create Instance under Excel VBO Business Object

[NivedN]

Hi all,

I had one doubt

What is use of Enable events option in create instance of Excel VBO business objects?

What is it importance?

Can anyone tell please



Regards
Nived N

[NicholasZejdlik]

Enable Events can be used to suppress event-driven macros from running. For example, if a workbook has a macro that runs when the workbook is activated, disabling events would prevent that macro from running. If you're using workbooks that don't have any macros set up on events, or if you're using a macro-less Excel file, then it won't really matter what you set Enable Events to.