MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Toggle images on a worksheet?

  Asked By: Steven    Date: Jan 04    Category: MS Office    Views: 1627

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:

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!



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Toggle images on a worksheet? Or get search suggestion and latest updates.