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


what is dml in sqlexcel sql command texttclsh commandsvba code to open excel file from foldervba display messageexcel developer ribbonresource allocation template excel freehow to unhide in excel 2013how to unhide all cells in excelcompare duplicates in excelvba msgbox vbcriticalvba tutorialhow to remove duplicates in excel sheetlocate duplicates in excelexcel 2003 pivot table tutorialshortcut key strikethrough excelunhide all sheets in excelexcel vba colour indexconvert from excel to xmlfilesystemobject deletefileunlock vba project passwordexcel vba unprotect workbook without passwordexcel vba with rangewhat is merge cells in excelunhide cells excelhow to create a data entry form in excel 2007protect a worksheet in excelddl dml and dclexcel vba delete entire rowexcel task trackermultiple if statements in excel 2010excel offset vlookupexcel vba create odbc connectiontypes of bar charts in excelexcel vba copy destinationexcel with vba programmingsas for beginnersdo while loop in vbavb6 check if file existsmicrosoft graphs and charts templatesexcel macro libraryselect sheet vbaworksheets vbaexcel checking for duplicatesexcel advanced filter criteria range examplesvbscript coding examplesconcatenate on exceldbms interview questions and answers for freshers pdfunprotect excel workbook without passwordwhile loop in vbadashboard formats in excelexcel vba return arrayvba declare variableexcel vba testaccess vba run querydelete blank rowsexcel vba uppercasesimple example of vlookup in exceluse of sumif in excelword activex controlscreate vba macroexamples of vlookuppassword log template excelaccess vba copy filecopy sheet to another sheet vbaexcel vba programming examples pdfexcel vba color cellvba case statement accessdcl in sql servervba close applicationdashboard powerpoint template freeenableevents vbahow to unprotect workbook in excelexcel hyperlink cell