This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I encountered an Excel 2010 on Win 7 machine where the default value of Application.EnableEvents is FALSE.
It shows FALSE in the Immediate Window as below:
?Application.EnableEvents
False
This behaviour happens before opening any workbook, and it persists even after forcing it to true and then closing Excel and re-opening it.
I disabled all add-ins without any effect.
This behaviour is so strange because on any other machine, the default is TRUE and even switching it to FALSE does not persist to subsequent Excel launch.
This property is not available on Excel options and can only be changed by code. What could switch it to FALSE?
Thanks,
Dovy
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I have the same issue and I'm using Excel 2013. One of my users has all his spreadsheets opening with Application.EnableEvents set to FALSE, but it is set to TRUE for everybody else. I've tried everything with no luck! Very frustrating!
Excel started in safe mode, all add-ins are disabled and there is no Personal macro book anywhere.
Excel still opens with EnableEvents as FALSE.
Hello,
do you have any add-ins or a Personal.xls file that may be running code that you are not aware of?
Try opening Excel in Safe Mode, so no add-ins are applied. (Close Excel, then hold the Ctrl key down while clicking Excel on the Start Menu). Are Events still disabled? If not, then there is some code at work. Disable all add-ins and bring them back one by one. Check after each add-in until you find the culprit.