I have a very touchy Workbook that seems "crosspolinate"
if I open another excel spreadsheet. The guy working on
this decided to quit and I am stuck. All i want to do is
have the application open one by one. I am not sure where
to go but I am starting here. I am told that a good
measure is to uncheck the "windows in taskbar" option.
But it doesn't save. Would like to do this
programmatically.

Hi Doug,

I think for people in this forum to assist you, they need to see your code
where it "crosspolinates".

Here's what I would do:

1) Problem Definition....what is it that you WANT done, and what is
happening now?

2) What code is affecting your solution or causing crosspolination? Are you
able to isolate the code causing the problem? For example, can you single
step through the code to isolate where your crosspolination occurs?

3) Post the relevant segments of your code....but DO NOT attach your
workbook. If necessary and desired, someone here will provide their e-mail
address and you can correspond offline.

4) Any other comments that you feel are helpful.

This should help get you started. Because I am NOT a wizard at VBA, you
will likely be helped by someone else. But in any event, he or she will
need some information to work with in order to assist you.

If your problem requires that "someone work on it" you might want to request
the assistance of a paid professional. There are several that frequent this
forum and can assist. If, however, your problem is that you just need a few
things "tweaked," I am sure you will receive a lot of great advice.

I hope that helps get you started.

Best regards,
Kevin


"Doug Nichol" wrote in message
...
I have a very touchy Workbook that seems "crosspolinate"
if I open another excel spreadsheet. The guy working on
this decided to quit and I am stuck. All i want to do is
have the application open one by one. I am not sure where
to go but I am starting here. I am told that a good
measure is to uncheck the "windows in taskbar" option.
But it doesn't save. Would like to do this
programmatically.

Thats my problem. I can't tell where it does that. I was
trying to get around it by forcing the App to open in a
single instance.
-----Original Message-----
Hi Doug,

I think for people in this forum to assist you, they
need to see your code
where it "crosspolinates".

Here's what I would do:

1) Problem Definition....what is it that you WANT done,
and what is
happening now?

2) What code is affecting your solution or causing
crosspolination? Are you
able to isolate the code causing the problem? For
example, can you single
step through the code to isolate where your
crosspolination occurs?

3) Post the relevant segments of your code....but DO NOT
attach your
workbook. If necessary and desired, someone here will
provide their e-mail
address and you can correspond offline.

4) Any other comments that you feel are helpful.

This should help get you started. Because I am NOT a
wizard at VBA, you
will likely be helped by someone else. But in any
event, he or she will
need some information to work with in order to assist
you.

If your problem requires that "someone work on it" you
might want to request
the assistance of a paid professional. There are
several that frequent this
forum and can assist. If, however, your problem is that
you just need a few
things "tweaked," I am sure you will receive a lot of
great advice.

I hope that helps get you started.

Best regards,
Kevin


"Doug Nichol" wrote in message
...
I have a very touchy Workbook that
seems "crosspolinate"
if I open another excel spreadsheet. The guy working on
this decided to quit and I am stuck. All i want to do
is
have the application open one by one. I am not sure
where
to go but I am starting here. I am told that a good
measure is to uncheck the "windows in taskbar" option.
But it doesn't save. Would like to do this
programmatically.


.

Hi Doug,

You can start Excel without running the macro.

Try the following: (XL's help)

~~~~~~~~~~
Start Microsoft Excel without running automatic macros
Automatic macros, such as Auto_Activate, are designed to run when you start
Excel. For more information about these macros, see Visual Basic Help.

To prevent macros from automatically running, hold down SHIFT while you
start Excel.

Note If you start Excel from the Office Shortcut Bar, click the Microsoft
Excel button on the Office Shortcut Bar first, and then immediately hold
down SHIFT while Excel starts.
~~~~~~~~~~

Go Alt F11 to look at the code. You might be able to single step through
it.

Post some code so that people can begin to guide you where to look. Without
any code to guide the VBA gurus, it will be difficult.

Regards,
Kevin







"Doug Nichol" wrote in message
...
Thats my problem. I can't tell where it does that. I was
trying to get around it by forcing the App to open in a
single instance.