See

ftp://ftp.mcgimpsey.com/excel/PrintSize.xla

The add-in changes row heights back as well.

It uses a WIthEvents class to operate on all workbooks.

You can set the number of rows, number of columns, print width of
columns, and print height of rows in the "Globals" module.

In article .com,
wrote:

thanks for your kind reply..
only column width changes and not row height?!!


is it possible to make this an addin so i can have this on every
workbook?