Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Screen Flicker | Excel Discussion (Misc queries) | |||
List box screen flicker | Excel Discussion (Misc queries) | |||
Preventing screen flicker | Excel Discussion (Misc queries) | |||
Screen Flicker while processing | Excel Programming | |||
Screen Flicker | Excel Programming |