Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Templates
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Templates | Excel Discussion (Misc queries) | |||
Excel is opening templates as templates instead of as worksheets | Setting up and Configuration of Excel | |||
templates | Excel Discussion (Misc queries) | |||
Templates | Excel Discussion (Misc queries) | |||
templates | Excel Worksheet Functions |