Problems with EnableEvents on XP

[ghild]

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

 

[belzberg]

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

 

[ghild]

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...

 

[nkardas]

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.

 

[IRstuff]

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

TTFN