Program

[Jason Zischke]

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

[Jim Thomlinson]

Nope... Having multiple instances of Excel running is problematic anyways. My
recommendation would be to figure out how to do whatever you want to do in
one instances.
--
HTH...

Jim Thomlinson


"Jason Zischke" wrote:

> 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

[NickHK]

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" <[email protected]> wrote in message
news:[email protected]...
> 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

[Vic Eldridge]

Application.IgnoreRemoteRequests = True
will prevent other files from being opened when you double-click them in
Windows Explorer, if that's what you mean.


Regards,
Vic Eldridge


"Jason Zischke" wrote:

> 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