Hide embedded objects contained in row that is filtered out

J

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

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
 
Top