Now I'm confused - Personal.XLS refuses to open. Everything else under
XLSTART opens (verified by Workbook_open sub), but not personal.xls.

"sebastienm" wrote:

nope, no idea.
If there were some code somewhere closing the book right away, it should
still be there (even after your modif; like in an AutoOpen macro), so it
should continue to close right after being opened. And it s apparently not
the case. ...;No idea at all. Sorry.

Sebastien

"Don" wrote:

Works Now - all I did was create the sub:

Sub Workbook_open()
Msgbox "Open"
End Sub

in the This Workbook module,

then erased the sub. Seems to work.

I couldn't find any stray code anywhere that would have caused it to close.

Any ideas on a possible problem or why it misbehaved?

Thanks!
"sebastienm" wrote:

Could it be that the book is open then closed right away for some reasons?
To test, add a
msgbox "open"
in the Workbook_open sub of the ThisWorkbook module of the book.

Sebastien

"Don" wrote:

Yea, tried that, but doesn't work. It opens up an XLA file I have, but not
Personal.XLS. In fact, it opens any file EXCEPT personal.xls. Any ideas?

"sebastienm" wrote:

Hi,
By default, Excel opens any book in the following directory upon startup.
Just place your book the
C:\Documents and Settings\<username\Application Data\Microsoft\Excel\XLSTART
(Replace <username with your login name)

You can choose a different directory in menu Tools Options, tab General,
'Alternate Startup Directory'.

Regards,
Sebastien

"Don" wrote:

How do I get Excel to open PERSONAL.XLS macro spreadhseet upon startup, and
have it reside in the background to make my MACROs available to all Excel
spreadsheets?