Macro to hide and unhide columns works in 2003 but not in 2010

[hhod]

I'm using the following to hide blank columns when column A is autofiltered to a specific selection, unhides/rehides when the selection changes. Works great in excel 2003, but is freezing up the workbook in excel 2010. Any help is appreciated!

Please Login or Register  to view this content.

[Kaper]

Hi hhod.
Can you attach the sample file where freezing occurs? (of course - no delicate data).
I made a dummy and tested it both 2003 and 2010 and works just fine - may be the problem is not in this particular event handler (Worksheet_Calculate), butr somewhere else?

[hhod]

Hi,

I've determined that if I hit F9 after I've seleced a product from column A the macro will run and everthing works how its supposed to, but I dont want to have to hit F9 everytime. Attached is a sample file, thanks for the help!