EnableEvents Property of Application Object VBA

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.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


VBA EnableEvents Application Property – Syntax

Here is the syntax for EnableEvents Property of application object in Excel VBA.

Application. EnableEvents

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.

LIMITED TIME OFFER

Leave A Comment


Related pages


excel vba create workbookhow to use name manager in excel 2010ifs in exceluserform excel 2010vba cell formatworksheets in vbavlookup demouse of vlookup and hlookupexcel dashboards templateshow to learn excel vbavba cutdrop down boxes in excel 2007free excel dashboards templatesvba cellssql update vbavba excel import text filelearning excel macroexcel macro hide worksheetvba instr syntaxvlookup and hlookup tutorialexcel formulas shortcut keys 2007embed forms combobox 1excel color indexwhat is descending order in excelmacro in excel exampleshortcut to insert row in excelexcel formulas average ifshow developer tab excel 2010excel remove duplicate lineshow to protect excel worksheetexcel vba copy range to another worksheetrun excel macro on openexcel vba screen updatingbar of pie excelhow to find duplicate value in excelvba array examplefind duplicate entry in excelformula for adding a column in excelcombo box in visual basichow to hide tabs in exceldeclare variables vbaunprotect an excel fileexcel how to change rows to columnsexcel macro to select a cellfind duplicates in excellhighlight duplicates excel 2010vba delete filehow to remove duplicate records in excelvba code to unprotect sheetwww vlookup formula excelexport vbadeclaring array vbasimple excel commandsexcel macro iconvb interview questionadd drop down in excel 2007isna in excelexcel spreadsheet for project managementunprotect macro excelproject charter template ppthow to use sumif in excel 2007vba copyexcel vba lookupin excel vlookup formula exampleremove duplicates in excel columnhow to add developer tab to the ribbon in wordexcel tickunprotect xls filesort excel spreadsheetcreate checkbox in excelwhat is vlookup formula in excelswitch case vbaaccess vba messageboxusing excel lookupexcel merge sheets into one workbook