Solved

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

Posted on 2011-09-20
3
242 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

Database Solutions Engineer FAQs

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

632 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