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
(E-Mail Removed)
"JeremyJ" <(E-Mail Removed)> wrote in message
news:5B8B8500-3631-4F3F-B03A-(E-Mail Removed)...
>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
> (E-Mail Removed)
> "JeremyJ" <(E-Mail Removed)> wrote in message
> news:5B8B8500-3631-4F3F-B03A-(E-Mail Removed)...
> >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 <Jere...@discussions.microsoft.com> 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
> > dguille...@austin.rr.com
> > "JeremyJ" <Jere...@discussions.microsoft.com> wrote in message
> >news:5B8B8500-3631-4F3F-B03A-(E-Mail Removed)...
> > >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 -