Prevent A Macro From Running If SpreadSheet is Filtered
 

I've been using macro that does not work well if I happen to have some of the
columns filtered (it works fine if auto filter is on but no columns are
actually filtered).

Is there a way to prevent the macro from running (and maybe displaying a
prompt that says "unfilter"). After the prompt I do not want the macro to
continue. I would then manually start it after unfiltering the columns.

Thank you in advance.

Hi Carl

In your macro you can use this to test if the filter is on

If ActiveSheet.FilterMode Then




--
Regards Ron de Bruin
http://www.rondebruin.nl


"carl" wrote in message ...
I've been using macro that does not work well if I happen to have some of the
columns filtered (it works fine if auto filter is on but no columns are
actually filtered).

Is there a way to prevent the macro from running (and maybe displaying a
prompt that says "unfilter"). After the prompt I do not want the macro to
continue. I would then manually start it after unfiltering the columns.

Thank you in advance.