I don't want to create a new template - just make minor adjustments to the
default template, eg landscape rather than portrait, printing with gridlines,
etc.

Update Book.xlt or Sheet.xlt (available in XLStart folder)

The XLStart folder is usually located at:

C:\Program Files\Microsoft Office\Office11\XLStart

For more details visit
http://office.microsoft.com/en-us/ex...292861033.aspx

"Polly" wrote:

I don't want to create a new template - just make minor adjustments to the
default template, eg landscape rather than portrait, printing with gridlines,
etc.

I doubt very much if Polly has these in her XLSTART folder.

They have to be created first.

See my reply to Polly.


Gord

On Mon, 8 Sep 2008 09:48:05 -0700, Sheeloo
wrote:

Update Book.xlt or Sheet.xlt (available in XLStart folder)

The XLStart folder is usually located at:

C:\Program Files\Microsoft Office\Office11\XLStart

For more details visit
http://office.microsoft.com/en-us/ex...292861033.aspx

"Polly" wrote:

I don't want to create a new template - just make minor adjustments to the
default template, eg landscape rather than portrait, printing with gridlines,
etc.

You are right Gord...

I did not think of that...

"Gord Dibben" wrote:

I doubt very much if Polly has these in her XLSTART folder.

They have to be created first.

See my reply to Polly.


Gord

On Mon, 8 Sep 2008 09:48:05 -0700, Sheeloo
wrote:

Update Book.xlt or Sheet.xlt (available in XLStart folder)

The XLStart folder is usually located at:

C:\Program Files\Microsoft Office\Office11\XLStart

For more details visit
http://office.microsoft.com/en-us/ex...292861033.aspx

"Polly" wrote:

I don't want to create a new template - just make minor adjustments to the
default template, eg landscape rather than portrait, printing with gridlines,
etc.

Open a new workbook. Customize as you wish.

FileSave 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 FileNew or the Toolbar button
FileNew or CTRL + n

WARNING................Do not use FileNew...Blank Workbook or you will get
the Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

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

More can be found on this in Help under "templates"(no quotes).


Gord Dibben MS Excel MVP

On Mon, 8 Sep 2008 08:57:02 -0700, Polly
wrote:

I don't want to create a new template - just make minor adjustments to the
default template, eg landscape rather than portrait, printing with gridlines,
etc.

If you create macros that you want to make available to all documents, do you
create a default template as described in this thread and store them athere
or is there another way

"Gord Dibben" wrote:

Open a new workbook. Customize as you wish.

FileSave 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 FileNew or the Toolbar button
FileNew or CTRL + n

WARNING................Do not use FileNew...Blank Workbook or you will get
the Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

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

More can be found on this in Help under "templates"(no quotes).


Gord Dibben MS Excel MVP

On Mon, 8 Sep 2008 08:57:02 -0700, Polly
wrote:

I don't want to create a new template - just make minor adjustments to the
default template, eg landscape rather than portrait, printing with gridlines,
etc.

No, either store them in Personal.xls, or create an addin.

--
__________________________________
HTH

Bob

"GregNga" wrote in message
...
If you create macros that you want to make available to all documents, do
you
create a default template as described in this thread and store them
athere
or is there another way

"Gord Dibben" wrote:

Open a new workbook. Customize as you wish.

FileSave 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 FileNew or the Toolbar button
FileNew or CTRL + n

WARNING................Do not use FileNew...Blank Workbook or you will
get
the Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

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

More can be found on this in Help under "templates"(no quotes).


Gord Dibben MS Excel MVP

On Mon, 8 Sep 2008 08:57:02 -0700, Polly

wrote:

I don't want to create a new template - just make minor adjustments to
the
default template, eg landscape rather than portrait, printing with
gridlines,
etc.

Where should Personal.xls be stored?

So, are you saying that default attributes such as landscape rather than
portrait, printing with gridlines, etc as indicated in the original question
in this thread by Polly should be stored in BOOK.xlt or SHEET.xlt (according
to reply by Gord Dibben) while to make macros available to all documents,
they should be stored in PERSONAL.xls


"Bob Phillips" wrote:

No, either store them in Personal.xls, or create an addin.

--
__________________________________
HTH

Bob

"GregNga" wrote in message
...
If you create macros that you want to make available to all documents, do
you
create a default template as described in this thread and store them
athere
or is there another way

"Gord Dibben" wrote:

Open a new workbook. Customize as you wish.

FileSave 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 FileNew or the Toolbar button
FileNew or CTRL + n

WARNING................Do not use FileNew...Blank Workbook or you will
get
the Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

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

More can be found on this in Help under "templates"(no quotes).


Gord Dibben MS Excel MVP

On Mon, 8 Sep 2008 08:57:02 -0700, Polly

wrote:

I don't want to create a new template - just make minor adjustments to
the
default template, eg landscape rather than portrait, printing with
gridlines,
etc.

To create a Personal.xls file go to ToolsMacrosRecord New Macro and "Store
Macro In". Select Personal Macro Workbook.

Record some simple steps like copy/paste some data.

Your Personal.xls will be created and when saved will be stored in the
default Office location.

Good idea to Save Personal.xls at this point. You will find it under
WindowUnhide

Save it and Excel will point it to the proper location.

Generally this is the location.

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

Now, if you have existing macros in other workbooks, you can copy them into
a module or modules of Personal.xls by hitting Alt + F11 to go to Visual
Basic Editor, CTRL + r to open Project Explorer.

Select Personal.xls and you can open the module1 containing your recently
recorded macro.

Add macros by copying them from other books(assuming you have some)

Go back to Excel Window by Alt + q

WindowHide your Personal.xls again then close Excel.

You will be given a message asking to save changes to Personal.xls

Click yes so it opens hidden when next you start Excel

Your macros will be available to all open workbooks from now on.

It will be up to you to devise a method of running them from a button,
shortcut key or by just running from ToolsMacroMacros list.

Note: recorded macros must be edited to run on ActiveWorkbook and
ActiveSheet rather than hard-coded names



Gord


On Sun, 4 Jan 2009 11:01:00 -0800, GregNga
wrote:

Where should Personal.xls be stored?

So, are you saying that default attributes such as landscape rather than
portrait, printing with gridlines, etc as indicated in the original question
in this thread by Polly should be stored in BOOK.xlt or SHEET.xlt (according
to reply by Gord Dibben) while to make macros available to all documents,
they should be stored in PERSONAL.xls


"Bob Phillips" wrote:

No, either store them in Personal.xls, or create an addin.

--
__________________________________
HTH

Bob

"GregNga" wrote in message
...
If you create macros that you want to make available to all documents, do
you
create a default template as described in this thread and store them
athere
or is there another way

"Gord Dibben" wrote:

Open a new workbook. Customize as you wish.

FileSave 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 FileNew or the Toolbar button
FileNew or CTRL + n

WARNING................Do not use FileNew...Blank Workbook or you will
get
the Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

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

More can be found on this in Help under "templates"(no quotes).


Gord Dibben MS Excel MVP

On Mon, 8 Sep 2008 08:57:02 -0700, Polly

wrote:

I don't want to create a new template - just make minor adjustments to
the
default template, eg landscape rather than portrait, printing with
gridlines,
etc.

I was answering your question as where to store macros. Template format
changes should be stored in a template, whether that be a custom template,
or the default workbook, Book.xlt.

--
__________________________________
HTH

Bob

"GregNga" wrote in message
...
Where should Personal.xls be stored?

So, are you saying that default attributes such as landscape rather than
portrait, printing with gridlines, etc as indicated in the original
question
in this thread by Polly should be stored in BOOK.xlt or SHEET.xlt
(according
to reply by Gord Dibben) while to make macros available to all documents,
they should be stored in PERSONAL.xls


"Bob Phillips" wrote:

No, either store them in Personal.xls, or create an addin.

--
__________________________________
HTH

Bob

"GregNga" wrote in message
...
If you create macros that you want to make available to all documents,
do
you
create a default template as described in this thread and store them
athere
or is there another way

"Gord Dibben" wrote:

Open a new workbook. Customize as you wish.

FileSave 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 FileNew or the Toolbar button
FileNew or CTRL + n

WARNING................Do not use FileNew...Blank Workbook or you
will
get
the Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

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

More can be found on this in Help under "templates"(no quotes).


Gord Dibben MS Excel MVP

On Mon, 8 Sep 2008 08:57:02 -0700, Polly

wrote:

I don't want to create a new template - just make minor adjustments
to
the
default template, eg landscape rather than portrait, printing with
gridlines,
etc.