How to stop template worksheet visibility
 

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

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

How to stop template worksheet visibility
 

Tom, thanks!

What I did was open the file, then Alt+F11 to open the IDE. In the
workbook window I selected the Window - Hide menu option. In the
IDE's immediate window, I executed this code:
ThisWorkbook.Close savechanges:=True

Now to find some new files to work on....

Eugene

How to stop template worksheet visibility
 

Now when I use the template to create a new file, the new workboo
file is hidden. How can I use this template that has a hidde
workbook to create new files that have visible workbooks

Eugen

How to stop template worksheet visibility
 

TTT...still need help on this one