Thread: Templates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Templates

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