Is 'IgnoreRemoteRequests' the same as....

D

dim

....'IgnoreOtherApplication'.

One of my books references in passing, the IgnoreOtherApplications VBA
command so that double-clicking an XLS file in Explorer won't use my instance
of Excel.

I want to use this, but when I type in as far as "Application.Ig"VBA code,
the predictive help only shows 'IgnoreRemoteRequests'.

Will IgnoreOtherApplication still work, or do I need a different command?
Its Excel 2002.

Thankyou.
 
J

Jim Thomlinson

Ignore other applications and ignore remote requests is the same thing... Be
careful using this code as it is a presistent setting and if your code bombs
in some way and fails to return this setting to it's original position you
are going to end up with a buch of very confused users... Good error handling
is necessary.
 
D

dim

Thankyou.

I haven't really learned how to enter error handling code yet, so I figure I
can't go wrong putting it in the AutoOpen macro, and disabling it in the
AutoClose. I'll put it in at the very end of development when I know that
none of my code is going to go bust when executed.......
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top