Prevent A Macro From Running If SpreadSheet is Filtered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top