+ Reply to Thread
Results 1 to 2 of 2

Minimum Row Height?

  1. #1
    PBS
    Guest

    Minimum Row Height?

    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



  2. #2
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1