Startup option

  • Thread starter Thread starter MS Excel
  • Start date Start date
M

MS Excel

Hi,

I have a custom template for Excel. Which I want to be opened when ever I
click NEW button in EXCEL.

Any idea
 
Why not just create a shortcut to the template, and use that to start
Excel instead of the usual shortcut? That way you'll have the bet of
both worlds.

Mark

-----Original Message-----
From: MS Excel [mailto:o[email protected]]
Posted At: 10 October 2005 09:03
Posted To: microsoft.public.excel
Conversation: Startup option
Subject: Startup option


Hi,

I have a custom template for Excel. Which I want to be opened when ever
I click NEW button in EXCEL.

Any idea
 
Sorry, misread your post (I replied to the subject, rather than the
body!). If you right click on the toolbar and choose Customize, then the
commands tab, then click on the "New" button on the toolbar, you can
choose "Modify Selection>Assign Hyperlink>Open, and then point the
button at your template.

Alternatively, leave that one as it is so you CAN still have a blank
Workbook, and modify any other button to point to your template.

Mark

-----Original Message-----
From: Mark R Penn [mailto:[email protected]]
Posted At: 10 October 2005 09:09
Posted To: microsoft.public.excel
Conversation: Startup option
Subject: Re: Startup option


Why not just create a shortcut to the template, and use that to start
Excel instead of the usual shortcut? That way you'll have the bet of
both worlds.

Mark

-----Original Message-----
From: MS Excel [mailto:o[email protected]]
Posted At: 10 October 2005 09:03
Posted To: microsoft.public.excel
Conversation: Startup option
Subject: Startup option


Hi,

I have a custom template for Excel. Which I want to be opened when ever
I click NEW button in EXCEL.

Any idea
 
But remember that that will replace your standard "blank workbook" template.
I prefer to keep that, and create fresh shortcuts to other templates I want
to run.

I assume there must be some easy way to get the standard Book.xlt template
back if you do overwrite it?

Mark
 
created book.xlt and pased in "C:\Program Files\Microsoft
Office\Office10\XLStart" but invain...it didn't worked...
I had practiced the same in 97 a few years ago.. but in Excel XP its not
working.

Please advise if i am making some mistake...its driving me crazy
 
Have you tried simply re-directing the "new" button to the template you
want?

Mark

MS Excel said:
created book.xlt and pased in "C:\Program Files\Microsoft
Office\Office10\XLStart" but invain...it didn't worked...
I had practiced the same in 97 a few years ago.. but in Excel XP its not
working.

Please advise if i am making some mistake...its driving me crazy
Click to expand...
 
Depending on how you upgraded excel, you may have multiple XLStart folders. And
if you have multiple book.xlt throughout those folders, excel may not use the
one you want.

To find the current XLStart that excel wants to use...

open excel
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
?application.startuppath
For me (winXP and xl2003), I get:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

Find all the book.xlt files you can (or check each of the XLStart folders you
have).

Close excel
windows start button|search
look for book.xlt
And delete/move/clean up the ones not in the correct location.

(I'd delete all the "wrong" book.xlt's and just keep the one in that folder.)

Then when you click the New Icon on the standard toolbar, you should get a
workbook based on that template file.
 
There really isn't a standard book.xlt workbook. If you've created a new
book.xlt and stored it in you're XLStart folder and don't want to use it, you
can delete it (or move it to a safe location).

Alternatively, you can click File|New... and choose Blank workbook
(xl2002+ works ok this way--I don't recall about xl2k and below)
 
yeah.. it work for single click only.. and after that it don't create new
file..


Mark R Penn said:
Have you tried simply re-directing the "new" button to the template you
want?

Mark
Click to expand...
 
Amazingly its working.. I just deleted all book.xlt and did as you
advised... its working..
thanks.
 
Back
Top