Jason,
If you use Application Level Events you can trigger code that runs when a WB
is opened.
However it has no cancel, so would have react after it is open.

See www.cpearson.com/excel/AppEvent.htm

NickHK

"Jason Zischke" wrote in message
...
Hi all,

Is there a way to prohibit another excel file opening up in the same
window
as the program that I have created?

Jason