![]() |
Adding Sheet using Template creates link
I have a macro which adds sheets to a workbook (.xlsm) based upon a
custom template (.xltm). The line of code which does this is: Sheets.Add Type:="<pathfilename.xltm" Doing so causes excel to create a link to the .xltm file. I can see the link by going to Data ribbon, and clicking on Edit links in the Connection group. I also tried doing this manually by inserting a sheet based upon the template file and the same thing happens. Why? This doesn't happen in Excel 2003. Is there a flag in Excel 2007 which indicates I don't want a link back to the source file that I need to set? This is either a new "feature" in Excel 2007 or a bug..... - John. |
All times are GMT +1. The time now is 12:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com