Tom,

You're right, it's not the default. The default is True. You have to
change it. But at least it's persistent. You don't have to set it every
time you open the file. :)
--
Earl Kiosterud
www.smokeylake.com

"Tom Ogilvy" wrote in message
...

However, I don't believe that is the default.

--
Regards,
Tom Oglvy

"Earl Kiosterud" wrote in message
...
Tom,

If the ShowModal property of the UserForm is set to False, vbModeless
param
in the Show method isn't necessary. Available in xl2002. Don't know
about
2000.
--
Earl Kiosterud
www.smokeylake.com

"Tom Ogilvy" wrote in message
...
Userform1.show

shows a modal userform, like a message box. All code halts except for
interaction with the userform.

If you have xl2000 or later you can do

Userform1.Show vbModeless

which will allow your code to continue.

--
Regards,
Tom Ogilvy

"dominicb"
wrote
in
message ...

Good evening SWMagic

To suppress all screen activity use this line as the first in your
macro:

Application.ScreenUpdating=False

and to turn it on again use:

Application.ScreenUpdating=True

(although, technically you don't need to because screen updating will
be restored at the end of a macro when control of excel is returned to
the user).

To display any kind of message, just design a userform (from the VBE
Insert Userform) showing your message and to call it from within
your
macro use this instruction:

UserForm1.Show

and to remove it use:

Unload UserForm1

HTH

DominicB


--
dominicb

------------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
View this thread:
http://www.excelforum.com/showthread...hreadid=399932