Re: How to stop template worksheet visibility

Tech-Archive recommends: Speed Up your PC by fixing your registry

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" <leaftye@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in message news:erIE1xPnFHA.1416@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>


.

Quantcast