ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't insert custom worksheet template (https://www.excelbanter.com/excel-discussion-misc-queries/87049-cant-insert-custom-worksheet-template.html)

S Car Go

Can't insert custom worksheet template
 
I have created a custom worksheet template and saved it in my templates
folder. When I try to insert the worksheet by right clicking on the tab,
selecting insert, and selecting my template, nothing happens. Nothing is
inserted.

RagDyeR

Can't insert custom worksheet template
 
Are you trying to insert a template into another WB?

If so, are you right clicking in a tab of the WB and *not* the template?


--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"S Car Go" <S Car wrote in message
...
I have created a custom worksheet template and saved it in my templates
folder. When I try to insert the worksheet by right clicking on the tab,
selecting insert, and selecting my template, nothing happens. Nothing is
inserted.



S Car Go

Can't insert custom worksheet template
 
Yes, I am trying to insert a template into another WB. Yes, I am right
clicking in a tab of the WB.


"RagDyeR" wrote:

Are you trying to insert a template into another WB?

If so, are you right clicking in a tab of the WB and *not* the template?


--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"S Car Go" <S Car wrote in message
...
I have created a custom worksheet template and saved it in my templates
folder. When I try to insert the worksheet by right clicking on the tab,
selecting insert, and selecting my template, nothing happens. Nothing is
inserted.




Gord Dibben

Can't insert custom worksheet template
 
Snail

Save the template as SHEET.XLT and store it in your XLSTART folder. Not in the
templates folder.

Usually found here.............

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

That will be the default new worksheet.


Gord Dibben MS Excel MVP

On Fri, 5 May 2006 08:24:01 -0700, S Car Go <S Car
wrote:

I have created a custom worksheet template and saved it in my templates
folder. When I try to insert the worksheet by right clicking on the tab,
selecting insert, and selecting my template, nothing happens. Nothing is
inserted.



RagDyeR

Can't insert custom worksheet template
 
I can't seem to duplicate your problem.

Even on a 'sheet protected', WB, I can insert a template.

When the WB is protected, the 'Insert' option is grayed out.

On a 'shared' WB, an error message displays, denoting that the particular
command is not available.

Exactly what happens when you click "Insert"?
Are you automatically directed to the <Files <New folder, where you can
choose your template??
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"S Car Go" wrote in message
...
Yes, I am trying to insert a template into another WB. Yes, I am right
clicking in a tab of the WB.


"RagDyeR" wrote:

Are you trying to insert a template into another WB?

If so, are you right clicking in a tab of the WB and *not* the template?


--

Regards,

RD
--------------------------------------------------------------------------

--
-------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------------

--
-------------------

"S Car Go" <S Car wrote in message
...
I have created a custom worksheet template and saved it in my templates
folder. When I try to insert the worksheet by right clicking on the tab,
selecting insert, and selecting my template, nothing happens. Nothing is
inserted.







All times are GMT +1. The time now is 06:05 PM.

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