Minimum Row Height?

  • Thread starter Thread starter PBS
  • Start date Start date
P

PBS

Is it possible to set a "Minimum Row Height", without restricting the
ability for the row height to grow if required by a cells contents?

I'm trying to find a way to introduce some white space in the line spacing.
In word this would be similar to Format . . .Paragraph . . .Spacing Before /
Spacing After.

Any suggestions?

Thanks,
Paul
 
Not ideal but will set the row size upon selection to a mininmum value.
Users can still use the mouse to change

Rightclick on the sheet tab name and select "View Code" then paste this in
to the resulting window....

Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.RowHeight < 13 Then Target.RowHeight = 13
End Sub


Change both "13"'s to whatever value you like.

Users will still be able to resize rows but as soon as they do
 
Back
Top