LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default vbApplication-NOT-Modal

Hi,

Is there anyway to make vbApplicationModal = False...?

I have an Excel macro which opens up a message box - when this message box
is open, I want the user to be able to use othe Excel workbooks except for
the one displaying the message box...

There doesn't seem to be a way to do this...

for some reason vbApplicationModal seems to be the default, as well as the
only option (ie. default is true, and the only option is to set it as true -
booyeah!)
 
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
Forms that are modal in 97 are not modal in 2003 Old Car Excel Discussion (Misc queries) 1 April 27th 05 08:25 AM
Forms that are modal in 97 are not modal in 2003 Old Car Excel Programming 1 April 27th 05 08:25 AM
MODAL vs. NonMODAL JimP Excel Programming 5 November 18th 04 01:21 PM
Non-Modal InputBox? NooK[_38_] Excel Programming 3 July 9th 04 04:58 PM
Modal oddity Ken McLennan[_3_] Excel Programming 2 May 27th 04 06:49 AM


All times are GMT +1. The time now is 02:24 PM.

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"