hiden sheet

[scrabtree]

I have a hidden sheet and depending on the order of when
other macros have been ran, the sheet may or may not be
autofiltered. I need a code that will look at the hidden
sheet and turn off the autofilter if it is on and not do
anything if it is not.

 

[Bob Flanagan]

If ActiveSheet.AutofilterMode then activesheet.usedrange.autofilter

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Tom Ogilvy]

Slightly different:

If worksheets("hiddensheetname").AutofilterMode then _
worksheets("hiddensheetname").AutofilterMode = False

 

[David C.]

and I add an other detail:
(if you do not want the whole used range to be autofiltered)


with range("A1:A10") ' put here the head of wanted colmuns

' this deactivate it if already used ANYWHERE ON THIS SHEET:
If .AutoFilter Then: .AutoFilter ' (when no arguments, just toggle)

' this activate it on the right cells:
..AutoFilter 1, , , , True

end with