View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How to stop template worksheet visibility

Open the template file
Hide it.
Use the immediate window to close and save it.

Now when it is opened, it should be hidden like personal.xls

--
Regards,
Tom Ogilvy


"leaftye - ExcelForums.com" wrote
in message ...
I have a custom template I use to create new files. It has a toolbar
that references macros in the template file. The problem is that
when I run the macros, the template file becomes opens in the
background. How can I access the macros from the template (they're
in modules) but keep the template invisible, or is there another way
I should be using the macros? Thanks for taking your time to check
this out!

Eugene