[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

Excel 2007 File > New set the workbook

Hi experts.

I want to set the default book that opens with I click Office Button > New in Excel 2007.  I have placed my book.xltx file in the XLSTART startup location of:

C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART

This works well and comes into affect when I OPEN the application - my workbook opens as the default workbook.

However, I want this workbook to open when I click Office Button > New. I've tried putting it in
C:\Users\<username>\AppData\Roaming\Microsoft\Templates
no luck

I've tried naming it Sheet and putting it in
C:\Users\<username>\AppData\Roaming\Microsoft\Templates
but no luck.

Help??
0
Fi69
Asked:
Fi69
1 Solution
 
Rory ArchibaldCommented:
You would have to override the builtin command using XML (see Ron's site here for instructions: http://www.rondebruin.nl/ribbon.htm).
Alternatively, use Ctrl+N or the New button on the Quick Access Toolbar instead and your template will be used.
0
 
Fi69Author Commented:
Thanks Rorya, I've done what you've suggested as a solution. I had noticed the the quick access button and Ctrl+N shortcut generated the correct workbook. It amazes me that the File > New > workbook doesn't target the same workbook. Seems crazy to me!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now