webmaster escreveu:Valdecirrk,
Primeiro, grave a macro deletando a figura de uma planilha. Cole ela aqui e tentamos automatizar.
Att
em cada planilha tem a mesma imagem uma sobre a outra, segue a macro.
Sub Macro1()
'
' Macro1 Macro
' Macro gravada em 8/10/2013 por weg
'
'
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 1", "Picture 2", "Picture 3", "Picture 4" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 2", "Picture 3", "Picture 4", "Picture 1")).Select
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 17", _
"Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 2" _
, "Picture 3", "Picture 4", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 2", "Picture 3")).Select False
ActiveSheet.Shapes.Range(Array("Picture 4", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 2", "Picture 3", "Picture 4", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 2" _
, "Picture 3", "Picture 4", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 17", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 2", "Picture 3")).Select False
ActiveSheet.Shapes.Range(Array("Picture 4", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 1", "Picture 2", "Picture 3", "Picture 4" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 2" _
, "Picture 3", "Picture 4", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 2", "Picture 3" _
, "Picture 4", "Picture 1", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 17", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 1", "Picture 2", "Picture 3", "Picture 4" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 2", "Picture 3", "Picture 4", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 2" _
, "Picture 3", "Picture 4", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 2", _
"Picture 3" _
, "Picture 4", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 17", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 2", "Picture 3", "Picture 4")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 2", "Picture 3", "Picture 4", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 2", _
"Picture 3" _
, "Picture 4", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 2", "Picture 3", "Picture 4" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 17")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 2", "Picture 3", "Picture 4", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 2" _
, "Picture 3", "Picture 4", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 2", "Picture 3", "Picture 4" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 2", "Picture 3", "Picture 4", _
"Picture 1" _
, "Picture 1", "Picture 1", "Picture 17", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 2" _
, "Picture 3", "Picture 4", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 2", _
"Picture 3" _
, "Picture 4", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 2", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 4" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 4" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 2", "Picture 3", "Picture 4", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 2" _
, "Picture 3", "Picture 4", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 17", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 2", "Picture 3")).Select False
ActiveSheet.Shapes.Range(Array("Picture 4", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 1", "Picture 2", "Picture 3", "Picture 4" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 2" _
, "Picture 3", "Picture 4", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 2", "Picture 3" _
, "Picture 4", "Picture 1", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 17", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 1", "Picture 2", "Picture 3", "Picture 4" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 2", "Picture 3", "Picture 4", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 2", "Picture 3" _
, "Picture 4", "Picture 1", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 2", "Picture 3", _
"Picture 4" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 17" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 2", "Picture 3", "Picture 4", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 2" _
, "Picture 3", "Picture 4", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 2")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 2", "Picture 3", "Picture 4", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 2" _
, "Picture 3", "Picture 4", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 17", "Picture 1", _
"Picture 1" _
, "Picture 1", "Picture 1", "Picture 2", "Picture 3" _
, "Picture 4", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 2", "Picture 3", "Picture 4")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 2" _
, "Picture 3", "Picture 4", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 2", _
"Picture 3" _
, "Picture 4", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 17", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 2", "Picture 3", "Picture 4")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 2", "Picture 3", "Picture 4", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 2", _
"Picture 3" _
, "Picture 4", "Picture 1", "Picture 1", "Picture 1" _
, "Picture 1", "Picture 2", "Picture 3", "Picture 4" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 17")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 2", "Picture 3", "Picture 4", "Picture 1" _
, "Picture 1", "Picture 1", "Picture 1", "Picture 2" _
, "Picture 3", "Picture 4", "Picture 1", "Picture 1")).Select False
ActiveSheet.Shapes.Range(Array("Picture 1", "Picture 1", "Picture 1", _
"Picture 1" _
, "Picture 1", "Picture 1")).Select False
Selection.Delete
End Sub