Help accessing properties of an image

[reneuend]

I copy/pasted an image on an Excel Worksheet. I'd like to have it display or be hidden based on when a user changes a cell value or presses a button.

How do I access this image? I changed the name from "Picture 9" to "picValChanged" using the Excel field for naming named ranges.

thx for any help.

 

[RoryA]

You can use:

activesheet.shapes("picValChanged")

for example.

 

[reneuend]

Thanks Rorya. For some reason I wasn't able to find this on the net!

 

[MickG]

Hi this will Hide or Unhide the picture each time the code is run.

[COLOR="Navy"]Sub[/COLOR] MG26Apr22
[COLOR="Navy"]With[/COLOR] ActiveSheet.Shapes("picValChanged")
.Visible = True = .Visible = False
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]With[/COLOR]
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

 

[RoryA]

Or:

Sub MG26Apr22
With ActiveSheet.Shapes("picValChanged")
.Visible = Not .Visible
End With
End Sub