It sounds like you're opening the template file.
You could add a parameter to that .open command:
Workbooks.Open Filename:="C:\my documents\excel\book1.xlt", editable:=False
or you could just use .add
workbooks.Add template:="c:\my documents\excel\book1.xlt"
VickyC wrote:
Good Afternoon,
Sorry but I am a little new to templates in Excel.
I have created a template, which I would like to add to a toolbar,
which I thought I had done although when I click on it, it opens the
the actual template where as I want it to open a version of it?
Please can anyone help with how I can do this??
Thanks,
--
VickyC
------------------------------------------------------------------------
VickyC's Profile: http://www.excelforum.com/member.php...o&userid=27391
View this thread: http://www.excelforum.com/showthread...hreadid=490752
--
Dave Peterson