Warning message: "Fixed Objects will move" What is its meaning?

[John Rogerson]

I get the warning message Fixed Objects will move in an Office 2000 Excel spreadsheet.
This occurs when filtering. To proceed with the filter operation I have to answer OK to the dialog box many many times.
I cannot find any references to this warning on the web or in Excel help.
Does anyone have an explanation?
Specifically -
What are these fixed objects?
How can I identify them and to where they have been moved?
How can I avoid the warning and the need to press <return> 100's of times?
Regards

 

[Debra Dalgleish]

The following MSKB article may help:

XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
http://support.microsoft.com/default.aspx?id=211769

Also, Dave Peterson posted this advice:
'================
Someone with the same problem posted back that their comments were
getting resized causing the trouble.

Maybe enabling: Tools|Options|View|Comment and indicator
(at least for a little bit will help.)
'========================

Or, perhaps William's suggestion in the following posting will help:

http://groups.google.com/groups?hl=en&selm=#SyiwlGICHA.2580@tkmsftngp09

He advised the following:
'=======================
"if you have a button on your worksheet, right click on the button,
select "Format Control", select "Properties" and then select "Move and
Size with cells"
'========================

 

[John Rogerson]

Thanks Debra, deleting some comments seems, on a quick test, to have solved the problem. Testing will continue...