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