P
Paul_B
Hi,
I'm new to Excel, '03. I've set up a default template, book.xlt,
in the xlstart folder, and excel is reading it properly.
Now I want to add some macros. Problem is, when I open the VB
editor, Insert a Module, then try to save it, the VB editor
prompts me to save it as a new file rather than part of book.xlt.
If I try to overwrite book.xlt, of course it won't let me because
that file is still open in excell; if I try to first close that
file the VB editor closes with it. So I'm stuck.
Obviously I'm missing something basic.
Thanks,
p.
I'm new to Excel, '03. I've set up a default template, book.xlt,
in the xlstart folder, and excel is reading it properly.
Now I want to add some macros. Problem is, when I open the VB
editor, Insert a Module, then try to save it, the VB editor
prompts me to save it as a new file rather than part of book.xlt.
If I try to overwrite book.xlt, of course it won't let me because
that file is still open in excell; if I try to first close that
file the VB editor closes with it. So I'm stuck.
Obviously I'm missing something basic.
Thanks,
p.