SelectionChange Event Glitch

J

JeremyJ

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
 
N

Nigel

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unload a Form using SelectionChange 5
How to retrieve the last selected cell before SelectionChange even 2
Change in cell disabling events 1
Sharing xls file with macro (xlsm) 0
Select Cell and open UserForm 2
what takes precedence between change and selectionchange? 1
Error 1004 when I try to Union ranges - why? 1
SelectionChange Event 5

Top