Excel version?

If 2003, see http://www.codeforexcelandoutlook.co...eet-templates/

--JP

On Oct 13, 3:31*pm, Bill wrote:
How do you change the default settings on a new excel doc so that when you
open a new doc it contains the settings (especially the page set-ups) you
want? *I can change the settings on the doc which opens @ start-up, but once
I'm in excel, when I open a new doc it doesn't have the setting I need.
--
William Reilly

JP, thank you. This works when starting excel. My problem is once I'm in
excel and I want to open a NEW document from the menu bar, it opens a new
document wihout my desired settings. I guess I can just select FILE and open
the initial document again, as long as it was one of my recent documents.

I guess I'm being lazy.
--
William Reilly


"JP" wrote:

Excel version?

If 2003, see http://www.codeforexcelandoutlook.co...eet-templates/

--JP

On Oct 13, 3:31 pm, Bill wrote:
How do you change the default settings on a new excel doc so that when you
open a new doc it contains the settings (especially the page set-ups) you
want? I can change the settings on the doc which opens @ start-up, but once
I'm in excel, when I open a new doc it doesn't have the setting I need.
--
William Reilly

Not sure what you mean. If you set up book.xlt and sheet.xlt and save
in your XLSTART folder, you can press Ctrl+N or click the "New" button
on the Standard toolbar and get a new workbook customized as you did
with the template. What you cannot do (as Gord instructed) is go to
File New... and choose "Blank workbook."

--JP

On Oct 15, 11:05*am, Bill wrote:
JP, thank you. *This works when starting excel. *My problem is once I'm in
excel and I want to open a NEW document *from the menu bar, it opens a new
document wihout my desired settings. *I guess I can just select FILE and open
the initial document again, as long as it was one of my recent documents.

I guess I'm being lazy.
--
William Reilly