I hope someone can help me with this one....
I have a bunch of logos which I want to use on my worksheet. I want the user to
select the desired logo using a combobox with the clients name... so when a
certain client is selected, their logo is displayed next to the combobox on the
sheet, consequently the other logos should disappear.
I know how to hide the logos on the sheet by making visibility false:
ie.
ActiveSheet.Shapes("Picture 1").Select
Selection.ShapeRange.Visible = False
The problem is making them reappear again using the same code... it doesn't work
because apparently it doesn't recognize the object anymore when its hidden!
so trying
ActiveSheet.Shapes("Picture 1").Select
Selection.ShapeRange.Visible = True
gives an error!