HI:

I created an Excel VBA (VBATest.xls) and I put the xls file in the
XLStart Directory and whenever I load other excel file, I can run the
macro that is defined in my VBATest.xls file. The only problem is when
I load any excel file, it also opens up another blank excel
application (which says VBTest.xls). I think there is a way to prevent
that to startup while the sub function in my VBATest.xls is still
available to other excel files. Any ideas?

Thank you.

Peter

Hi
i would either put this macro in your personal.xls file or create an
addin (*.xla file)

--
Regards
Frank Kabel
Frankfurt, Germany

"Peter" schrieb im Newsbeitrag
om...
HI:

I created an Excel VBA (VBATest.xls) and I put the xls file in the
XLStart Directory and whenever I load other excel file, I can run the
macro that is defined in my VBATest.xls file. The only problem is
when
I load any excel file, it also opens up another blank excel
application (which says VBTest.xls). I think there is a way to
prevent
that to startup while the sub function in my VBATest.xls is still
available to other excel files. Any ideas?

Thank you.

Peter