Thread: show modal
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default show modal

Mark,
The userform gets the focus irrespective of the vbModal value. But this
seems to work :

UserForm1.Show vbModeless
AppActivate Application.Caption

NickHK

"mark" wrote in message
...
I'm using a form to display some messages, as my process is working. I

have
it set to showModal = false, so that it's just an info message, not

something
that has to be clicked off.

But, every time the message is to be displayed, it does grab focus. Can
this be prevented?