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 sheet rangeexcel combine spreadsheetshow do we merge cells in excelhow to create a named range in excel 2010vba combobox multiple columnsvba variant typeadodb.recordset exampleexcel concatenate worksheetsvba databasepv table excelinterview aptitude questions and answers with explanationsort selected cells by last name in ascending ordervba listshow to merge cells excel 2010vba code to open excel fileexcel vba activecell.formulaexcel remove duplicates from two columnsexcel 2010 autofit row heightppt project plan templatehow to unhide columns in excelrows excel vbaexcel vba wait functiontick on excelhow to use concatenate in excel 2007vba copy to new workbookremove macro excelexcel formula and operatorms word meeting minutes templatesimple vba code for excelexcel 2007 vba tutorialvba excel graphcountifs excel formulaworkbooks.close vbaexcel macro create sheethow to run a macro in exceltutorial on vlookuphow to select entire column in excelname manager excel 2010vba close workbookms excel templates for project managementexcel application.getopenfilenameexcel advanced tutorialexcel vba formulasinserting charts in excelvba nested if statementsvba remove duplicates from arrayexcel dashboard kpiexcel dashboards and reports 2010ms excel shortcut keys formulaspivot table dynamic rangehow to sort a column alphabetically in excelvisual basics for excelworkbooks.open filenameexcel filter vbatrim functionvba entire row deleteexcel delete double entriesshortcut key for change sheet in excelshort cut excelvba iferrorprogramming excel vbacombo box vba excelcreate a pivot chartsort sql statementvba code vlookuptutorial pivotexcel mergingvba trim spacesmicrosoft word project plan templateexcel macro stringvba scripting in excelexcel with vba programmingexcel roadmap templatevlookup vba excelhow to copy cells in excel to another sheet