View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
k1sr k1sr is offline
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!)