Solved

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

Posted on 2011-09-20
3
241 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

751 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