Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CreateEventProc for OLE button crashes Excel Jag Man Excel Programming 3 February 18th 04 11:25 PM
Using CreateEventProc fails when used with a Worksheet. George Doster Excel Programming 3 October 22nd 03 04:22 PM
Excel crashes with createEventProc for a button Dave Peterson[_3_] Excel Programming 0 August 25th 03 11:31 PM
Excel crashes with createEventProc for a button Tom Ogilvy Excel Programming 4 August 25th 03 08:30 PM
Excel crashes with createEventProc for a button tina salgia Excel Programming 0 August 25th 03 06:17 PM


All times are GMT +1. The time now is 09:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"