Macro for hiding rows not working

[sunilwadhwa]

Hi,

I’ve a macro to hide certain rows if I select a value on cell J6 from a dropdown data validation list. Everything works perfect until I select the option “ALL” from the list. Once I select “ALL” on J6 the workbook stops responding and then I have to use task manager to end the process.

Can someone please help me fix this issue with the vba code. Have attached a sample workbook along with the vba code.

Regards,
SWSample Data.xls

[rvasquez]

Hey there,
Try updating you entire coding behind the Sector Dashboard to just look like this. I believe the rest might be unneccessary.

Please Login or Register  to view this content.

[bheanloh]

I added Application.EnableEvents to your clear_filters code

Please Login or Register  to view this content.

[sunilwadhwa]

That was quick. Thanks so much for all your help!!!!

[rvasquez]

Thanks for the star tap!