Autofilter toggle problem
 

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

Autofilter toggle problem
 

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.

--
Regards,
Tom Ogilvy


"CLR" wrote:

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

Autofilter toggle problem
 

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" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"CLR" wrote:

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

Autofilter toggle problem
 

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.

--
Regards,
Tom Ogilvy


"CLR" wrote in message
...
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" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"CLR" wrote:

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

Autofilter toggle problem
 

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" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"CLR" wrote in message
...
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" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"CLR" wrote:

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

Autofilter toggle problem
 

Could be corrupted.

--
Regards,
Tom Ogilvy


"CLR" wrote in message
...
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" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"CLR" wrote in message
...
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" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"CLR" wrote:

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

Autofilter toggle problem
 

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


"Tom Ogilvy" wrote in message
...
Could be corrupted.

--
Regards,
Tom Ogilvy


"CLR" wrote in message
...
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" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"CLR" wrote in message
...
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" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"CLR" wrote:

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