for the instance of excel using your form, set the IgnoreRemoteRequests
property of the Application Object to false and perhaps that should allow
users to get a different instance of excel. This is equivalent to going into
tools=Options and in the general tab, selecting Ignore Other applications.
See if that gives you the functionality you want.

the queryclose event of the form should allow you to control closing of your
userform.

--
Regards,
Tom Ogilvy


"Duncan" wrote:

Hi all,

Firstly can I just agree with Pianoman that this is definately the best
forum I have come across and always get an answer. Very satisfied with
the level of compassion and helpfulness here!

Anyway, I posted the other day about this timetracker im trying to
create, now i have nearly finished it but I want to iron out some
problems with opening instances of excel.

As the form opens up vbmodless I minimise the application behind it so
that it looks standalone, I also have borrowed a lot of code from
formfun.

But what would be the best approach if people want to use excel for
other things at the same time? I know I can get things to open in their
own instance by opening excel first and then file open the file I want,
but if people click on shortcuts to excel docs then it just shows the
form and does nothing, likewise in many other situations.

Is there a better way of making this thing fairly standalone as I want
it to always be on screen while the users are doing other things, or
should I change the way users open their other excel docs?

Any help would be great on this as im not really clued up on modeless
apps and only really want the form to stay open until closed (ive
allowed the minimise button so it dont get in the way) and I would love
it to be not closed except by my close button.

Any ideas anyone?

Many thanks in advance

Duncan