Autofilter toggle problem

[Guest]

Hi All.......

I have a 4 meg Excel program that uses the AutoFilter extensively throughout
it's macros, and has been working fine for several years. Now, all of a
sudden, if I cycle the AutoFilter on and off, two times.....it causes some
sort of corruption. Several of the AutoFilter drop down arrows do not
dissappear the second time around, yet are unfunctional. Also, several of my
drawing rectangles that I use to trigger other macros just dissappear! It
does this no matter how I cycle the AutoFilter, by macro or even if I do the
regular Data > Filter > AutoFilter sequence by hand. There are no
ChangeEvent macros.....at least not any that I put in, nor can see. Could
someone have installed a "hidden" macro that I don't know where it might
be?.....could this be a virus?

Anybody ever heard of this, or have any ideas?

TIA
Vaya con Dios,
Chuck, CABGx3

 

[Guest]

It sounds like you might be deleting shapes and somehow your method of
determining which ones to delete has gotten out of kilter.

If this sounds likely, then you might want to look at that code.

The dropdown arrows in the Autofilter are part of the shapes collection.

Also, if you are adding controls, perhaps the default names are causing
duplicates, or has gotten too high.

 

[CLR]

Thanks for the thoughts Tom, but I think it must be something else. I
"fixed" the problem by using a 2 week old file and just copy and pasteing
the new input data over to it and putting it back on line. So, the
"emergency" is over, but I still would like to know what was wrong.

The file has been working fine for several years. I do not do any
deleting of shapes or figures, only the Autofiltering and copying and
pasting of data into special reports. All of a sudden within the last 2
weeks something has happened, or has been done to the program to make it do
this. If I do not enable macros, I still get a error message saying there
is a Excel 4.0 macro that it can't delete. I did not include such a macro
in my design, but one could have been added later. I do not know how to
check for one. But, when I start without enabeling macros and click yes to
that error message, none of my macros work, but I still get the same
problem. I guess the next step is to just start deleteing modules and
worksheets until the problem might can be isolated some more.

Thanks again for your thoughts, and if you know how I might find that XL40
macro, please advise.

Vaya con Dios,
Chuck CABGx3

 

[Tom Ogilvy]

Excel4 macros are found on Macro sheet. Loop through the sheets collection
and make each sheet visible.

Is it possible that someone used the Addin
Template Wizard with Data Tracking.

I believe that puts a hidden macro sheet in the workbook, but I could be
misremembering.

 

[CLR]

To make a long story short, I stripped out everything I could, all sheets
except one main sheet, all modules, all macros, all named ranges, and Format

Sheets > unhide showed nothing.....still had the problem. Started over,

created a new sheet and copied all the stuff over from my old main sheet to
the new sheet. The problem does not exist on the new sheet (which has the
same name as the old main sheet) and the old main sheet (now renamed) still
has the problem, and I still get the "Excel4Macro" pop-up when trying to
start without macros. And it's not an Excel thing cause I get the problem
on two machines at work and this one here at home, and the same file saved
from 2 weeks ago does not exhibit the problem, so it is IN this file.
Obviously it has something to do with that old main sheet that I replaced,
but what could it be?

Vaya con Dios,
Chuck, CABGx3

 

[Tom Ogilvy]

Could be corrupted.

--
Regards,
Tom Ogilvy

To make a long story short, I stripped out everything I could, all sheets
except one main sheet, all modules, all macros, all named ranges, and Format
created a new sheet and copied all the stuff over from my old main sheet to
the new sheet. The problem does not exist on the new sheet (which has the
same name as the old main sheet) and the old main sheet (now renamed) still
has the problem, and I still get the "Excel4Macro" pop-up when trying to
start without macros. And it's not an Excel thing cause I get the problem
on two machines at work and this one here at home, and the same file saved
from 2 weeks ago does not exhibit the problem, so it is IN this file.
Obviously it has something to do with that old main sheet that I replaced,
but what could it be?

Vaya con Dios,
Chuck, CABGx3




all if

 

[CLR]

I reckon you're right Tom.......I also ran this code to see if there were
any veryhidden sheets and nothing showed up....

Sub Un_Hide_All()
Dim sh As Worksheet
For Each sh In Worksheets
sh.Visible = True
Next
End Sub

So, I guess there's nowhere else to look for a problem, it's just one of
those weird things......

Thanks for your time and consideration.

Vaya con Dios,
Chuck, CABGx3