Start up file

A

abee

I have been reading about how to change the worbook Excel
uses when File|New is selected. This seems helpful to me
as it would allow me to re-customise every new workbook
to suit me. Is the file used by Excel on File|New the
same one as it uses on Startup? - if not can I make it so.

I have also heard about storing Macros in a personal
Excel file so that the macros are always available - how
does this work - are these macros attached to the default
workbook (referred to above)?

Thank You for your help

Abee
 
D

davers

abee said:
*I have also heard about storing Macros in a personal
Excel file so that the macros are always available - how
does this work - are these macros attached to the default
workbook (referred to above)?

Thank You for your help

Abee *
Click to expand...

Hi Abee,

Yes, I believe they are stored in your Personal.xls file (worksheet
file) that can be found in your XLSTART folder for Excel. On my
computer, Windows 2000, it is stored here: C:\Documents and
Settings\dmorri18\Application Data\Microsoft\Excel\XLSTART. I've put
quite a few helpful little bits of code in mine...everything from date
formatting a row, to adding blank rows in between data...

Hope this helps a little,

Have a good day,

Dave M.
 
G

Gord Dibben

Abee

Open a new workbook. Customize as you wish. File>Save As Type: scroll down
to Excel Template(*.XLT) and select. Name your workbook "BOOK"(no quotes).
Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New>Workbook.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT. It now becomes the default
Insert>Sheet.

NO...Personal.XLS is not the same default workbook as above.

Personal Macro Workbook contains macros available to all workbooks.

If you don't have a Personal Macro Workbook...........

On menu go to Tools>Macro>Record New Macro.

You will be presented with a dialog box with Macro1 as name of macro. Below
that is "Store macro in". Select Personal Macro Workbook.

Record something simple like copying a cell and pasting. Stop Recording.
Close Excel and you will be asked if you want to save changes to Personal.xls

Click Yes. You now have a Personal.xls which will open each time you start
Excel. When it is open, you can go to Windows>Hide and make it hidden. Save
changes again.

The macros you create or copy to modules in the Personal.xls will be available
for all workbooks.

Gord Dibben XL2002
 
J

JMay

Clap, Clap,Clap,Clap,Clap............
That was GREAT!!!!
You are a Pro !!
Thanks for allowing me to "listen-in"..
JMay
 
G

Gord Dibben

Thank you for the clap, clap part. The "listening in" part is for all. No
"allowing" in these News Groups.

I would not like to contemplate a time when the NG's would be by invitation
only.

Gord
 
Top