Auto Filter - "Fixed Objects Will Move"

  • Thread starter Thread starter mymk
  • Start date Start date
M

mymk

I am activating the auto filter feature for a file with about 60 tousan
rows. The message "Fixed Objects Will Move" keeps on coming u
everytime a filter is selected. How does one fix this problem?

Thanks for any info
 
Not had the error before but it sounds like you have other combo boxes, list
boxes, labels or shapes, etc on the worksheet which are moving with the
filter?

Just a thought

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
It sounds like you have an object somewhere in your data (a button/picture???)
that will move when you do the filter.

You can try to find the object:
Edit|goto|special|Objects

If you find it/them, you can rightclick on it (and depending on the object), you
can choose "Format Control", then Properties, then choose the way you want it to
move (Don't move???).

I'm not sure if this'll help with the autofilter, but you could try:
tools|options|edit tab
and uncheck "cut, copy, and sort objects with cells"
 
Back
Top