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

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
--
John

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=e...%40tkmsftngp09

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 wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

--
John


"Debra Dalgleish" wrote:

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=e...%40tkmsftngp09

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 wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html