Hide embedded objects contained in row that is filtered out
 

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?

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?