×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Problems with EnableEvents on XP

Problems with EnableEvents on XP

Problems with EnableEvents on XP

(OP)
I'm working with a rather complex XLA application that
previously had no problems involving EnableEvents when run
in Office 97/2000.  In Office XP it does crash however.  

Application.EnableEvents is set to False while a
subroutine populates the rows of a sheet with data stored
in memory.  Concurrently, a userform displays a progress
bar.  Previously, while the sheet was being populated, the user was able to click and highlight cells, or switch between sheets in the active workbook.  
On XP, however, do so results in the following error:

"Run-time error '50290': Method 'EnableEvents' of
object '_Application' failed."

Are there any known problems with EnableEvents in XP that
cause it to behave differently than in previous versions?

Thanks

RE: Problems with EnableEvents on XP

Hi there,

Did you solve the problem? I had the same error when migrate a spread sheet from 97/2000 to Excel XP.

Thanks,

Lynn

RE: Problems with EnableEvents on XP

(OP)
Actually no... we've tried, and put it off for awhile.  Actually, next week I am supposed to devote my time entirely to figuring out how to fix it.  Let me know if you have any insight into it...

RE: Problems with EnableEvents on XP

Hi,

I have excatly the same issue as you. I try to migrate a VBA app from Office 97/2000 to XP and I get the Run-time error '50290'. I have looked at many forums but it was not helpful.
Please help me if you can,

Nicolas.

RE: Problems with EnableEvents on XP

Have you tried posting this on Tek-Tips?  There are more resources there for this type of question.

TTFN

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources