Hide embedded objects contained in row that is filtered out

[Jim2003]

When using the >Data >Autofilter a row becomes hidden but if it contained an
embedded object it show in the next row that appears - bad.

how can embedded objects be hidden along with the row they are embedded in?

[Bob Umlas, Excel MVP]

select the object(s) and use Format/Selected Object (or format autoshape...),
then on the properties tab, select Move & Size with cells.

Bob Umlas
Excel MVP

"Jim2003" wrote:

> When using the >Data >Autofilter a row becomes hidden but if it contained an
> embedded object it show in the next row that appears - bad.
>
> how can embedded objects be hidden along with the row they are embedded in?