Start up file

  • Thread starter Thread starter abee
  • Start date Start date
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
 
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.
 
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
 
Clap, Clap,Clap,Clap,Clap............
That was GREAT!!!!
You are a Pro !!
Thanks for allowing me to "listen-in"..
JMay
 
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
 
Back
Top