If you know what sheet to keep, then you could delete the other 4.

If you're concerned that the names of the 5 inserted sheets may have changed,
you could create a new workbook based on that template, delete the 4 sheets you
don't need and then move that remaining sheet into your workbook.

Another alternative (maybe easier) is to just create a workbook with that single
sheet in it. And then use that for your template.

asmenut wrote:

What if the user just wants to add 1 sheet of the 5?

"Ron de Bruin" wrote:

Hi

You can add sheet templates like this
Sheets.Add Type:=Application.TemplatesPath & "\xxxxx.xlt"

--
Regards Ron de Bruin
http://www.rondebruin.nl



"asmenut" wrote in message
...
Thanks for the help earlier.

Now the problem is that I need to add the sheet(s) from an existing
template
(5 sheets avaiable) without having to open it. Any help would be greatly
appreciated.

Regards




--

Dave Peterson