Yes that does turn it on and off but that would turn it off when it is
on and on when it is off. That is the code I am currently using. The
problem is that sometimes there is an autofilter  already active on the
worksheet. Sooooo I need to turn it off when it is on and do nothing
when it is off. Also, because there are multiple tables on this one
worksheet the autofilter might be active on a different table than the
one I want to deal with so just using Activesheet.showalldata does not
work 100% of the time.