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
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
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
RE: Problems with EnableEvents on XP
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
TTFN