key controlled macros vs auto vba macros

[WILLFELD]

I have a macro that works on "ctrl d" assigned to a button.

i decided to have that macro run auto with vba worksheet_change on a single cell that changes dates.

When it run auto, some of the sort functions fail. If i then hit the button it works fine.

From the keyboard or button alls well, from the vba code it doesn't sort? no errors just doesn't sort

any ideas?

[jasoncw]

Without seeing your procedure, it would be hard to tell the reason for the failure to sort.

Jason