Personal.XLS MACRO Workbook

[Guest]

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?

 

[Guest]

Hi,
By default, Excel opens any book in the following directory upon startup.
Just place your book there:
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

 

[Guest]

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?

 

[Guest]

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

 

[Guest]

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!

 

[Guest]

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

 

[Guest]

Now I'm confused again. I insert the WorkBook_Open sub in all spreadsheets
under XLSTART, and they all respond - except for Personal.XLS. Could
something be preventing the workbook from openning? Maybe something coded as
an option in Excel?

 

[Guest]

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

 

[Guest]

The only thing i can think of right now is if a book/addin, that opens before
the Personal, sets the Application.EnableEvents to False. In that case, the
_Open of the personal wouldn't run. Such a property would be set through
code in one of these open addins/books. However, still, there some code that
closes the personal book, and you 've already looked into that and found
nothing.
The book could also be corrupted. Try to remove the book. create a new blank
one with just the Workbook_Open and a msgbox. Try this new one. Also try with
another name. Finally, if it work: Open the personal book and a blank book,
and in the vba ide, drag the code modules to the new book. Rename and save.

There is probably be some other explanation, but i don't see any right now.
Maybe someelse will have a better idea.

Regards,
Sebastien

 

[Guest]

I AM THOROUGHLY LOST. I open up the Personal.XLS through the WorkBook_Open
sub in Book1, and it seemed to work for a while. Now, the MACRO icons refer
to a file name I used just to get the things to work, and will not accept
assignment fo any MACRO under Personal.XLS. I try assigning it to a MACRO
under Personal.xls (and yes, the MACRO is available - I check it out under
Tools>MACROs>Visual Basic Editor)

Could there be a security setting that screws things up? I'm puzzled at the
randomness of this problem. Whe trying to assign a MACRO to an icon, they
all show, but refuse to be assigned.

 

[Guest]

Ok - I deleted everything (after exporting the MACRO modules), even the Book1
files, etc. Openned up Excel, which finally created Book1, entered Visual
Basic Editor, imported Module 1 (which consists only of comments), and saved
as Personal.XLS in XLSTART. Closed Excel, and re-oppened it - NO
PERSONAL.XLS. Renamed Personal.XLS to Personals.XLS, and Success!. Why
doesn't Excel like Personal.XLS?