All forms in Excel97 are shown "modally" which means that the
calling code will stop at the Show method until the form is
hidden. Excel 2000 and later can show forms "modelessly" which
means that code execution proceeds after immediately after the
Show method, but there is no reliable way to do this in Excel 97.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Syed Zeeshan Haider" wrote in message
...
Hello Experts,
I have Excel 97 Pro on Win98SE.

I have a certain piece of code in which UserForm1.Show stops
the macro?
E.g.

Public Sub SomeProcedure()

' some working code here

UserForm1.Show ' After this line, the macro
won't proceed

' some should-work code here

End Sub

Why does UserForm1.Show stop the macro?
Is there any way to prevent it?

Thank you,
--
Syed Zeeshan Haider



--------------------------------------------------
http://szh.20m.com
http://gomusharrafgo.20m.com