Oliver Ferns via OfficeKB.com
Guest
Re: Minimum Row Height?
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
--
Message posted via http://www.officekb.com
Bookmarks