3 Simple Questions

Hello all. Can someone please tell me how to solve these simple but irritating things?

1. How can I make a default font for footers? I have to change it from 10 point to 8 point every blasted time. Grrr...

2. How can I specify the default folder for "save as"? Right now it seems to default to the folder from which the file came, which is usually OK, but not when starting a new file.

3. How do I set the default zoom (and other defaults) for all new workbooks, worksheets, etc?

Thank you,

Larry

I believe you can do some of this with VBA macros. Do you know how to write
macros yet?

"Larryq22" wrote:

>
> Hello all. Can someone please tell me how to solve these simple but
> irritating things?
>
> 1. How can I make a default font for footers? I have to change it from
> 10 point to 8 point every blasted time. Grrr...
>
> 2. How can I specify the default folder for "save as"? Right now it
> seems to default to the folder from which the file came, which is
> usually OK, but not when starting a new file.
>
> 3. How do I set the default zoom (and other defaults) for all new
> workbooks, worksheets, etc?
>
> Thank you,
>
> Larry
>
>
> --
> Larryq22
> ------------------------------------------------------------------------
> Larryq22's Profile: http://www.excelforum.com/member.php...o&userid=33157
> View this thread: http://www.excelforum.com/showthread...hreadid=530993
>
>

I know macros, but I haven't heard of VBA macros.

#1 and #3: Look in Help for "Default settings" or "Custom Start up". In XP
this would give you a list of entires with "Customize how Excel starts" at
the top of hte list. That article has a link "Save workbook settings you
want to use every time..."
What you want to do is create an empty workbook with all your desired zooms,
print footers, etc. and save it (per Help instructions) as Book.xlt in a
specific place. Then, whenever a new workbook is created, it will use that
custom Book.xlt as a template. You can also create a single-sheet Sheet.xlt
that will be used (most of the time) when you insert a new sheet. Note that
these saved settings will only apply to new books & sheets.

#2. AFAIK, the Save/Open dialog opens to the "Current" directory. Each excel
*session* uses Tools>Options>DefaultFileLocation as a starting point for
Current but from then on Current = the "last browsed to" location as a
starting point. I don't know of any way to change that other than to write
some code that would change the default directory, probably using the ChDir
statement. I'm not 100% sure of this, so if someone chimes in saying I'm
wrong, you should probably listen to them :-) Even so, I don't know of any
events that are triggered when a new workbook is created, so I don't know
how you would know when to change the directory (i.e., there is no "easy"
place to put the code that would do what you want).

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Larryq22" <Larryq22.25wl5a_1144428600.4522@excelforum-nospam.com> wrote in
message news:Larryq22.25wl5a_1144428600.4522@excelforum-nospam.com...
>
> Hello all. Can someone please tell me how to solve these simple but
> irritating things?
>
> 1. How can I make a default font for footers? I have to change it from
> 10 point to 8 point every blasted time. Grrr...
>
> 2. How can I specify the default folder for "save as"? Right now it
> seems to default to the folder from which the file came, which is
> usually OK, but not when starting a new file.
>
> 3. How do I set the default zoom (and other defaults) for all new
> workbooks, worksheets, etc?
>
> Thank you,
>
> Larry
>
>
> --
> Larryq22
> ------------------------------------------------------------------------
> Larryq22's Profile:
> http://www.excelforum.com/member.php...o&userid=33157
> View this thread: http://www.excelforum.com/showthread...hreadid=530993
>