View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian Webster Ian Webster is offline
external usenet poster
 
Posts: 1
Default Screen Flicker when changing row height

I have a simple routine that uses a spin button to resize several rows
from a height of 2 to 12.75.

Sub Row_Height_Change()
Application.ScreenUpdating = False
UnProtectAllSheets
Sheets("Re-Issue Input Form").Select
If Sheets("Re-Issue Input Form").Range("Event_2_Row_Height").Value
= 1 Then
Range("13:18,26:31,39:44").Select
Selection.RowHeight = 12.75
Else
Range("13:18,26:31,39:44").Select
Selection.RowHeight = 2
End If
Application.ScreenUpdating = True
ProtectAllSheets
End Sub

I have turned the screen updating off but I still get a annoying
screen flicker. Does anyone know how I can eliminate this?

Thanks in advance for any answers.