View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JeremyJ JeremyJ is offline
external usenet poster
 
Posts: 27
Default SelectionChange Event Glitch

Using the Autofilter on a sheet calls the SelectionChange Event. When that
Event disables ScreenUpdating Excel freezes. I am using Excel 2007 with
Vista. Does anyone have this problem or know why it is happening? Is there a
work-around?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = False
End Sub