Excel Template
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 |
Excel Template
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 |
All times are GMT +1. The time now is 09:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com