EXCEL 2010 - Olap error - enable events property is set to false How to change to TRUE

Posted on 2011-09-20
Medium Priority
Last Modified: 2012-05-12
Where in Excel 2010 in VB do I set enableevents to set to true.
Can I please have the syntax to enter correctly, I know its VB but I am new to excel 2010

Would be grateful if I could get some assistance.
Question by:Amanda Walshaw
  • 2

Author Comment

by:Amanda Walshaw
ID: 36570896
Can I please get some help here thanks
LVL 12

Accepted Solution

kgerb earned 2000 total points
ID: 36571065
Well, maybe I'm not understanding the question fully nut isn't it just...

Application.enableevents = true

It can go anywhere in your procedure.


Author Closing Comment

by:Amanda Walshaw
ID: 36571443
thaks got it now

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question