Try it. The Excel file you try to open will not open. The User form holds the
copy of Excel so that you double click in Windows Explorer to open another
spreadsheet and it by default will try to open in the current instance of
Excel and nothing happens... The user form is in the way. The only way around
it will be to have the user open a second instance of Excel and open their
file their. They user will have to be very aware of which instance of Excel
is currently in focus before trying to open a file through windows explorer.
My preference is to not Hijack Excel in that way. Too many call from irate
end users... :-)
--
HTH...

Jim Thomlinson


"lotus" wrote:

>
> Jim Thomlinson Wrote:
> > How do you keep the end user from opening up a new workbook and having
> > it
> > land in the hidden coy of Excel?
> > --
> > HTH...
> >
> > Jim Thomlinson
> >
> >
>
> I think that will not happen. 'cause if the excel file is hidden out of
> view and only the userform is showing you will not be able to work on
> any other excel file.
>
>
> --
> lotus
> ------------------------------------------------------------------------
> lotus's Profile: http://www.excelforum.com/member.php...o&userid=23759
> View this thread: http://www.excelforum.com/showthread...hreadid=493436
>
>