I would like to have the row height set to "20" upon opening or creating a
new workbook. You can change the default setting for the column, why not for
the height of a row.

If there is a way to write a macro that will execute when that workbook is
open I would be interested in that also.

Thanks

If you go to your Personal.xls, and paste this code in the "ThisWorkbook"
page, it will automatically set the row height to 20. You may need to add
this to the new sheet activate as well.

Private Sub Workbook_Open()
Cells.Select
Selection.RowHeight = 20
End Sub


"Walter L. Skinner" <Walter L. wrote in
message ...
I would like to have the row height set to "20" upon opening or creating a
new workbook. You can change the default setting for the column, why not
for
the height of a row.

If there is a way to write a macro that will execute when that workbook is
open I would be interested in that also.

Thanks

How to find Personal.xls. I want to change the defualt setting of the row to
12.75? Please help! Thanks

"Sunil Jayakumar" wrote:

If you go to your Personal.xls, and paste this code in the "ThisWorkbook"
page, it will automatically set the row height to 20. You may need to add
this to the new sheet activate as well.

Private Sub Workbook_Open()
Cells.Select
Selection.RowHeight = 20
End Sub


"Walter L. Skinner" <Walter L. wrote in
message ...
I would like to have the row height set to "20" upon opening or creating a
new workbook. You can change the default setting for the column, why not
for
the height of a row.

If there is a way to write a macro that will execute when that workbook is
open I would be interested in that also.

Thanks

WL

I wouldn't bother with Personal.xls and code.

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

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 Excel MVP



On Tue, 16 Jan 2007 13:37:01 -0800, WL wrote:

How to find Personal.xls. I want to change the defualt setting of the row to
12.75? Please help! Thanks

"Sunil Jayakumar" wrote:

If you go to your Personal.xls, and paste this code in the "ThisWorkbook"
page, it will automatically set the row height to 20. You may need to add
this to the new sheet activate as well.

Private Sub Workbook_Open()
Cells.Select
Selection.RowHeight = 20
End Sub


"Walter L. Skinner" <Walter L. wrote in
message ...
I would like to have the row height set to "20" upon opening or creating a
new workbook. You can change the default setting for the column, why not
for
the height of a row.

If there is a way to write a macro that will execute when that workbook is
open I would be interested in that also.

Thanks