Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CAN ANYONE SOVLE THIS PROBLEM!!!
HERE'S THE CODE:
Dim NDXcode As String, StartLine As Long NDXcode = ActiveSheet.CodeName With ActiveWorkbook.VBProject.VBComponents(NDXcode).Cod eModule StartLine = .CreateEventProc("SelectionChange", "Worksheet") .InsertLines StartLine, _ <TEXT IS INSERTED HERE HERE'S THE ERROR: " the object invoked has disconnected from its client" and Excel crashes THE ERROR OCCURS AT .InsertLine StartLine,...BUT IT ALSO HAPPENS IF I SINGLE STEP TO THE PREVIOUS LINE AND TYPE IN THE IMMEDIATE WINDOW "Print StartLine" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CAN ANYONE SOVLE THIS PROBLEM!!!
What happens if you turn off Event trapping before you try to insert the
procedure? On Thu, 17 Mar 2005 10:31:04 -0800, "Jim Warren" wrote: HERE'S THE CODE: Dim NDXcode As String, StartLine As Long NDXcode = ActiveSheet.CodeName With ActiveWorkbook.VBProject.VBComponents(NDXcode).Cod eModule StartLine = .CreateEventProc("SelectionChange", "Worksheet") .InsertLines StartLine, _ <TEXT IS INSERTED HERE HERE'S THE ERROR: " the object invoked has disconnected from its client" and Excel crashes THE ERROR OCCURS AT .InsertLine StartLine,...BUT IT ALSO HAPPENS IF I SINGLE STEP TO THE PREVIOUS LINE AND TYPE IN THE IMMEDIATE WINDOW "Print StartLine" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CAN ANYONE SOVLE THIS PROBLEM!!!
I haven't tried that. But I will and let you know.
"Myrna Larson" wrote: What happens if you turn off Event trapping before you try to insert the procedure? On Thu, 17 Mar 2005 10:31:04 -0800, "Jim Warren" wrote: HERE'S THE CODE: Dim NDXcode As String, StartLine As Long NDXcode = ActiveSheet.CodeName With ActiveWorkbook.VBProject.VBComponents(NDXcode).Cod eModule StartLine = .CreateEventProc("SelectionChange", "Worksheet") .InsertLines StartLine, _ <TEXT IS INSERTED HERE HERE'S THE ERROR: " the object invoked has disconnected from its client" and Excel crashes THE ERROR OCCURS AT .InsertLine StartLine,...BUT IT ALSO HAPPENS IF I SINGLE STEP TO THE PREVIOUS LINE AND TYPE IN THE IMMEDIATE WINDOW "Print StartLine" |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
CAN ANYONE SOVLE THIS PROBLEM!!!
How do you turn off Event trapping?
"Jim Warren" wrote: I haven't tried that. But I will and let you know. "Myrna Larson" wrote: What happens if you turn off Event trapping before you try to insert the procedure? On Thu, 17 Mar 2005 10:31:04 -0800, "Jim Warren" wrote: HERE'S THE CODE: Dim NDXcode As String, StartLine As Long NDXcode = ActiveSheet.CodeName With ActiveWorkbook.VBProject.VBComponents(NDXcode).Cod eModule StartLine = .CreateEventProc("SelectionChange", "Worksheet") .InsertLines StartLine, _ <TEXT IS INSERTED HERE HERE'S THE ERROR: " the object invoked has disconnected from its client" and Excel crashes THE ERROR OCCURS AT .InsertLine StartLine,...BUT IT ALSO HAPPENS IF I SINGLE STEP TO THE PREVIOUS LINE AND TYPE IN THE IMMEDIATE WINDOW "Print StartLine" |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
CAN ANYONE SOVLE THIS PROBLEM!!!
I think she mean's
Application.EnableEvents = False -- Regards, Tom Ogilvy "Jim Warren" wrote in message ... How do you turn off Event trapping? "Jim Warren" wrote: I haven't tried that. But I will and let you know. "Myrna Larson" wrote: What happens if you turn off Event trapping before you try to insert the procedure? On Thu, 17 Mar 2005 10:31:04 -0800, "Jim Warren" wrote: HERE'S THE CODE: Dim NDXcode As String, StartLine As Long NDXcode = ActiveSheet.CodeName With ActiveWorkbook.VBProject.VBComponents(NDXcode).Cod eModule StartLine = .CreateEventProc("SelectionChange", "Worksheet") .InsertLines StartLine, _ <TEXT IS INSERTED HERE HERE'S THE ERROR: " the object invoked has disconnected from its client" and Excel crashes THE ERROR OCCURS AT .InsertLine StartLine,...BUT IT ALSO HAPPENS IF I SINGLE STEP TO THE PREVIOUS LINE AND TYPE IN THE IMMEDIATE WINDOW "Print StartLine" |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
CAN ANYONE SOVLE THIS PROBLEM!!!
Thanks Tom. I tried that and it didn't make any difference. Do you have any
ideas? Jim "Tom Ogilvy" wrote: I think she mean's Application.EnableEvents = False -- Regards, Tom Ogilvy "Jim Warren" wrote in message ... How do you turn off Event trapping? "Jim Warren" wrote: I haven't tried that. But I will and let you know. "Myrna Larson" wrote: What happens if you turn off Event trapping before you try to insert the procedure? On Thu, 17 Mar 2005 10:31:04 -0800, "Jim Warren" wrote: HERE'S THE CODE: Dim NDXcode As String, StartLine As Long NDXcode = ActiveSheet.CodeName With ActiveWorkbook.VBProject.VBComponents(NDXcode).Cod eModule StartLine = .CreateEventProc("SelectionChange", "Worksheet") .InsertLines StartLine, _ <TEXT IS INSERTED HERE HERE'S THE ERROR: " the object invoked has disconnected from its client" and Excel crashes THE ERROR OCCURS AT .InsertLine StartLine,...BUT IT ALSO HAPPENS IF I SINGLE STEP TO THE PREVIOUS LINE AND TYPE IN THE IMMEDIATE WINDOW "Print StartLine" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |