EnableEvents Application Property in Excel VBA is used to enable events for the specified object. It has Boolean value that is either True or False. Please find more details about EnableEvents Application Property in the following section. When EnableEvents property set to True, while running any procedure it will enable the events.
50+ Project Management Templates Pack
Excel PowerPoint Word
Advanced Project Plan & Portfolio Template
Ultimate Project Management Template
20+ Excel Project Management Pack
20+ PowerPoint Project Management Pack
10+ MS Word Project Management Pack
VBA EnableEvents Application Property – Syntax
Here is the syntax for EnableEvents Property of application object in Excel VBA.
Where EnableEvents as String.
In the above syntax Application represents object and EnableEvents is the Property of Application object.
VBA EnableEvents Application Property: Example 1
Please find the below example for EnableEvents Property of application object in excel VBA. The below example disables the event and saves the workbook. So that the events cannot perform any task.
Sub Appl_EnableEvents() Application.EnableEvents = False ThisWorkbook.Save Application.EnableEvents = True End Sub
VBA EnableEvents Application Property – Instructions
Please follow the below steps to execute the VBA code to save the excel file.
Step 1: Open any existing Excel Application.
Step 2: Press Alt+F11 – This will open the VBA Editor Window.
Step 3: Insert a code module from then insert menu.
Step 4: Copy the above code and paste in the code module which have inserted in the above step.
Step 5: Now press F5 to execute the code.
|Excel VBA Reference||Project Management Reference|