show hide picture in excel, How to hide or unhide all pictures and objects in Excel, excel,

show hide picture in excel, How to hide or unhide all pictures and objects in Excel, excel,
excel,
Microsoft excel,
show
hide,
object,
excel VBA,
VBA
PARTS1 LINK ///////////////////////////////
• show hide picture in e...
*************VBA CODE*********
Sub Macro1()
With ActiveSheet.Shapes("REC").TextFrame2.TextRange.Characters
If .Text = "Hide" Then
.Text = "Show"
ActiveSheet.Shapes("MANOJ").Visible = False
Else
.Text = "Hide"
With ActiveSheet.Shapes("REC")
ActiveSheet.Shapes("MANOJ").Left = .Left + .Width
ActiveSheet.Shapes("MANOJ").Top = .Top + .Height
ActiveSheet.Shapes("MANOJ").Visible = True
End With
End If
End With
End Sub
BY @MANOJ KUMAR MATH , FROM, BHORHA, SIMRI BAKHTIYARPUR, SAHARSA, BIHAR,