View Single Post
  #2   Report Post  
Sunil Jayakumar
 
Posts: n/a
Default

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