I don't believe the format facility has an event that can be trapped

You're right so the only option is some other event like SelectionChange:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("10:10").RowHeight < 15 Then
Range("10:10").RowHeight = 15
MsgBox "Please don't change row 10's height"
End If
End Sub

This goes in the sheet module.

--
Jim
"JLGWhiz" wrote in message
...
| Steven, I don't believe the format facility has an event that can be
trapped
| to control the row height. Maybe someone smarter than me could create
one,
| but there are no built in methods other than locking the sheet that I know
of.
|
| "Steven" wrote:
|
| And the % view also. Is that controllable. Thank you.
|
| "Steven" wrote:
|
| I want to control the row height by not allowing a user to chage it
but I
| dont want to protect the worksheet. Can this be done. All I have
thought of
| so far is on Auto_Open is to set the row height as I want it but that
does
| not give the user notice as they try to change the row height. When
they
| change it I would like to give a message that the row height cannot be
change
| and then set it back. Even if they have select more than one row or
if they
| do auto wrap...etc.
|
| Thank you,
|
| Steven