Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CreateEventProc for OLE button crashes Excel | Excel Programming | |||
Using CreateEventProc fails when used with a Worksheet. | Excel Programming | |||
Excel crashes with createEventProc for a button | Excel Programming | |||
Excel crashes with createEventProc for a button | Excel Programming | |||
Excel crashes with createEventProc for a button | Excel Programming |