avoiding VBEopen when using CreateEventProc
Bob,
I tried yr suggestion, which seemed like a good one, but find that my
call to my function which adds the eventproc apparently turns visible
back to true.
code snippet is
Application.VBE.MainWindow.visible = False
Debug.Print "Application.VBE.MainWindow.visible(1)?: " &
Application.VBE.MainWindow.visible
Call commonFunctions.insertSelectionChange(wkbNew)
Debug.Print "Application.VBE.MainWindow.visible(2)?: " &
Application.VBE.MainWindow.visible
resulting immediate window is
Application.VBE.MainWindow.visible(1): False
Application.VBE.MainWindow.visible(2): True
Is this typical behavior or does it reflect some behavior of the code
I'm writing to the SheetModule? (no, can't be the latter, the only
thing it does there and then is Dim startPoint As Long so I can get the
..CreateEventProc off to a good start)
Obviously enough suggestions gratefully received at this point; the
running App looks pretty dreadful with the VBE popping up in the
middle; will definately scare off the average punter! )-;
Matthew
|