I have "Worksheet_SelectionChange" code that alters the formating on the
sheet when I select a certain cell. For some reason excel freezes when I use
the Auto Filter. What should I do???

As always post your code. You probably didn't restrict the code to your
cell.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JeremyJ" wrote in message
...
I have "Worksheet_SelectionChange" code that alters the formating on the
sheet when I select a certain cell. For some reason excel freezes when I
use
the Auto Filter. What should I do???

I narrowed down the problem to ScreenUpdating. It ended up having nothing to
do with my formatting code. It's as simple as this....

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

Excel Freezes when I try to sort data using the Sort buttons in the
autofilter:
Sort A to Z
Sort Z to A
Sort by Color

When I click the "X" to close the program and click cancel when it asks me
if I want to save or not Excel unfreezes. I am using Excel 2007 with Vista.
Any ideas? Are you able to recreate this problem on your computer?


"Don Guillett" wrote:

As always post your code. You probably didn't restrict the code to your
cell.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JeremyJ" wrote in message
...
I have "Worksheet_SelectionChange" code that alters the formating on the
sheet when I select a certain cell. For some reason excel freezes when I
use
the Auto Filter. What should I do???

Hi

Without the entire code it's hard to tell.

But a guess would be that you don't turn on screenupdating at the end
of the sub.

---
Per

On 27 Dec., 20:05, JeremyJ wrote:
I narrowed down the problem to ScreenUpdating. *It ended up having nothing to
do with my formatting code. *It's as simple as this....

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

Excel Freezes when I try to sort data using the Sort buttons in the
autofilter:
* * Sort A to Z
* * Sort Z to A
* * Sort by Color

When I click the "X" to close the program and click cancel when it asks me
if I want to save or not Excel unfreezes. *I am using Excel 2007 with Vista. *
Any ideas? *Are you able to recreate this problem on your computer?



"Don Guillett" wrote:
As always post your code. You probably didn't restrict the code to your
cell.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JeremyJ" wrote in message
...
I have "Worksheet_SelectionChange" code that alters the formating on the
sheet when I select a certain cell. *For some reason excel freezes when I
use
the Auto Filter. What should I do???- Skjul tekst i anførselstegn -

- Vis tekst i anførselstegn -