Solved

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

Posted on 2011-09-20
3
239 Views
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.
0
Comment
Question by:Amanda Walshaw
  • 2
3 Comments
 

Author Comment

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

Accepted Solution

by:
kgerb earned 500 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.

Kyle
0
 

Author Closing Comment

by:Amanda Walshaw
ID: 36571443
thaks got it now
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now