Solved

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

Posted on 2011-09-20
3
237 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
Comment Utility
Can I please get some help here thanks
0
 
LVL 12

Accepted Solution

by:
kgerb earned 500 total points
Comment Utility
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
Comment Utility
thaks got it now
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

762 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

13 Experts available now in Live!

Get 1:1 Help Now