set row height upon opening excel

W

Walter L. Skinner

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
 
S

Sunil Jayakumar

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
 
G

Gord Dibben

WL

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

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 or the Toolbar button File>New

WARNING................Do not use File>New...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 Insert>Sheet.

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


Gord Dibben Excel MVP
 
Top