Is it possible to make row height static in Excel 2010

I have differing row heights depending on the data contained in the rows.

Every time I insert a new row it changes other rows to the default height.

Is there a way to make row heights remain static?

Thanks
JagwarmanAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
slubekConnect With a Mentor Commented:
Use SelectionChange method:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Rows(3).RowHeight = 20
End Sub

Open in new window

0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
No, it can always be adjusted. There is no "lock" option on row heights.
0
 
Rob HensonFinance AnalystCommented:
You can stop users formatting rows, including height, by protecting the worksheet. I don't believe this will stop any auto adjustment though.

Thanks
Rob H
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
JagwarmanAuthor Commented:
Hi Rob

Users need to be able to insert rows but thanks
0
 
tomfarrarCommented:
0
 
Rob HensonFinance AnalystCommented:
In the Protect Sheet dialog, there are various options that the user can still do after protection is applied; one these is to allow users to insert rows.

Thanks
Rob H
0
All Courses

From novice to tech pro — start learning today.