"Dave Peterson" skrev i en meddelelse
...
papou asked if you really saved the file as a template.

Yes i did

At the bottom of the File|SaveAs dialog, there's a: "Save As Type" box

Did you select "Template (*.xlt)" in that dropdown.

YES

(Change this first, then change the location to your network folder.)

===

If you did this, then when the users open this template, do they get the
template itself (with a name of mytemplate.xlt in the title bar) or do
they get
a new workbook based on that template (with a name of mytemplate1 (no
extension)

They get a new workbook based on the template call mytemplate1

Are the users doing File|New to create the new workbook?

YES

An alternative. Save your file as mytemplate.xls (just a regular
workbook), but
then use windows explorer to mark that file as ReadOnly. It isn't
foolproof,
but it's usually sufficient.

Yes, and then i now have made this as a backup :-)

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)

If SaveAsUI = False Then
MsgBox "Husk og brug 'Gem Som' når du gemmer denne fil", vbCritical

Cancel = True
End If

And that is okay for me.

Thanks for your help
Ole


Hi,

i am trying to save a xls file as a xlt file, but when i save it on
a
network share or "C:\" it don't
function as a XLT file (you can "save" it, it dosn't popup as " save
as"),
but if i save it
in the propper place (c:\documents and s...\ole\application
data\microsoft\template)
it works, is there a way to save it as C:\mytemplate.xlt where it
will
function as a xlt file.

AHA.
Ole





--

Dave Peterson