Hide embedded objects contained in row that is filtered out

[Guest]

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?

 

[Guest]

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