ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   add personal template to the insert worksheet dialog box (https://www.excelbanter.com/excel-discussion-misc-queries/251132-add-personal-template-insert-worksheet-dialog-box.html)

SheriTingle

add personal template to the insert worksheet dialog box
 
In Excel when you right click on the sheet tab and select 'Insert' the Insert
dialog box opens. Clicking the second tab 'SpreadSheet Solutions' offers
multiple templates to insert as a new tab. How do I add my own template to
this list so that when I follow the steps I am inserting a template I created.

Gord Dibben

add personal template to the insert worksheet dialog box
 
Create the template then store it in this folder.

C:\Program Files\Microsoft Office\Templates\1033

which is the Spreadsheet Solutions folder.

Or in General Folder

C:\Documents and Settings\username\Application Data\Microsoft\Templates


Gord Dibben MS Excel MVP

On Tue, 15 Dec 2009 15:04:06 -0800, SheriTingle
wrote:

In Excel when you right click on the sheet tab and select 'Insert' the Insert
dialog box opens. Clicking the second tab 'SpreadSheet Solutions' offers
multiple templates to insert as a new tab. How do I add my own template to
this list so that when I follow the steps I am inserting a template I created.



SheriTingle

add personal template to the insert worksheet dialog box
 
Thanks Gord!!! : )

"Gord Dibben" wrote:

Create the template then store it in this folder.

C:\Program Files\Microsoft Office\Templates\1033

which is the Spreadsheet Solutions folder.

Or in General Folder

C:\Documents and Settings\username\Application Data\Microsoft\Templates


Gord Dibben MS Excel MVP

On Tue, 15 Dec 2009 15:04:06 -0800, SheriTingle
wrote:

In Excel when you right click on the sheet tab and select 'Insert' the Insert
dialog box opens. Clicking the second tab 'SpreadSheet Solutions' offers
multiple templates to insert as a new tab. How do I add my own template to
this list so that when I follow the steps I am inserting a template I created.


.



All times are GMT +1. The time now is 10:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com