Maybe you could replace the hyperlink with a macro that creates a new workbook
based on that template file.
Option Explicit
Sub TestMe()
dim NewWkbk as workbook
set newwkbk = workbooks.add(template:="C:\yourtemplate.xlt")
end sub
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
You could assign this macro to a button from the Forms toolbar or any shape from
the drawing toolbar.
ebrasil wrote:
I need to do hiperlink to template document, but it doesn't work, because
open a template document to modification and dont open a new document.
Anyone know what I need to do?
--
Dave Peterson