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


merge excel cellmsgbox vba excelexcel vba functions tutorialexcel hyperlink vbaexcel vba learningexcel 2007 listboxexcel vba labelexcel remove duplicates from 2 columnsvba update queryaccess vba recordsetdeveloper ribbon in excelunlock file excelhow to unprotect excel 2010datevalue in excelhyperlink function in excelvlookup definitionexcel function iserrorvba open documentfind duplicate values in excelsql certification questions and answers pdfvlookup ms excelhow to fill color in excel cell using formulaexample sumifvba input boxcall worksheet function from vbams access insert into vbavba box inputexcel vba print formvba adodb.connectionmacro open excel fileexcel macro save filetechnical aptitude questions with answers pdfcell address vbahow to unlock excelchange date format in teradatacount if functionproject management spreadsheet templateexcel count rows in rangeunhide all sheets macroexcel surface chartvba code excelexcel ribbon menums excel syntaxexcel sheets exampleshow do i unhide a column in excelhow to insert a title in excelvba excel columnssample dashboard reportsexcel pie chart examplesvba excel select worksheetformula hlookupcount cells in range vbawriting a macro in excelexcel for beginners tutorialgantt chart project plan excel templategetopenfilename excelapplication calculation xlcalculationmanual vbaexcel vba rgbwhat is sumif functionhow to merge cells with data in exceldelete duplicates excel 2010excel project management template microsoftconditional statement in vbscripthow to unhide all columns in excelproject gantt chart template excelcapacity planning spreadsheet excelvba delete columnvba excel arrayexcel vlookup example downloadvba range commandfree excel dashboard widgetslearning excel for beginnerscreate folder vbavba access open formsum if function excelhow to unprotect excel sheet 2010vba message boxexcel vba delete column