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,

[@chamilasampath6841]

After save and close . Again not comming module

[@manojkumarexcel]

Save file as macro- enable

[@chamilasampath6841]

How to save this one

[@manojkumarexcel]

Do save as macro enable
1slt is xlsx format
2nd one is xlsm formate
Chose 2nd while saving