Personal in Excel 2003

  • Thread starter Thread starter Mike H.
  • Start date Start date
M

Mike H.

I have a personal.xls file in my xlstart path. If I save it as a .xlt file,
it does not open automatically. If I save as a .xls file it opens but
remains active. I don't want to close it, I just want it "out of the way".
How do I do this? And should I use a .xlt file? If so how do I get it to
"auto-load"?
 
hi
the personal.xls should be a xls and not an xlt. the personal.xls should be
hidden.
in this way, it wont show but all of your personal macros will be available.


regard
FSt1
 
Open excel.
with personal.xls visible, use Window|Hide
close excel
answer yes to the "do you want to save your changes" prompt.

reopen excel to test.
 
Make it .xls
Run Excel; with Personal as the active workbook; use Windows | Hide
Now save and exit
Next time you run Excel, Personal will open but it will not be visible
best wishes
 
To add my 2 cents worth.

*.XLT files in XLSTART folder will not "autoload" in any case.

Everything else will try to open<g>


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Template on Server 2008 5
Personal.xls gone 6
Auto-displaying a template when Excel is launched 1
saved templates opening as templates 2
converting excel 2003 to 2007 file formats 18
Insert sheet template loses page setup (2010) 2
Transferring Custom Toolbar from One Machine to Another 3
how do we get 2003 .xlb toolbars and custom macros to show in 07 1

Back
Top