Templates

E

ebrasil

I need to do hiperlink to template document, but it doesn't work, because
open a template document to modification and don’t open a new document.
Anyone know what I need to do?
 
D

Dave Peterson

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.
 
Top