You should write the add in such that it does not require a
workbook to be open.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"big t" wrote in message
...
Hi everyone.

I have inherited an add-in that has to be always-on , on my
users' machines.
It also need to do some stuff in its Auto_Open sub.

Trouble is, if I don't include:

Application.Workbooks.Add

in the Auto-Open code I get an Excel crash (Excel 2003, Windows
XP). And
some of my users want to open Excel (and the add-in) but
without a blank
workbook appearing.

Any ideas? Is it imperitive for Excel to have a blank workbook
when it first
opens? Is this an Excel setting somewhere?

TIA,
big t