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

I'm using Excel 2007 (SP1) on Vista and it is not freezing! Do you have
other code / events that might also be running that is causing the problem?

--

Regards,
Nigel




"JeremyJ" wrote in message
...
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