I am currently running Excel 2003. After I have opened a worksheet that
contains a macro, i try to open a second document that also conatains a macro
and the second document will not open properly. The second document opens in
design mode.

My macro security settings are set to medium so as to prompt me before
opening a document with a macro contained within it. Is there a reason why I
am unable to open multiple documents with moacros in the at the same time?