Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I am using the following code which allows me to select a person from a dropdown and their signature (jpg) appears. It all works well but the code hides all the other pictures on the sheet (i.e. all the other signatures). This is what I want it to do but I also have a company logo on the sheet which I don't want to hide. How do I exclude this one picture from the "hiding" code? Option Explicit Private Sub Worksheet_Calculate() Dim oPic As Picture Me.Pictures.Visible = False With Range("K46") For Each oPic In Me.Pictures If oPic.Name = .Text Then oPic.Visible = True oPic.Top = .Top oPic.Left = .Left Exit For End If Next oPic End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is it possible to create a dropdown list with pictures/icons ? | Excel Discussion (Misc queries) | |||
Pictures in dropdown lists | Excel Discussion (Misc queries) | |||
Pictures in Dropdown | Excel Discussion (Misc queries) | |||
Multiple dropdown list with pictures | Excel Discussion (Misc queries) | |||
Change sheet name on linked cell by dropdown box | Excel Worksheet Functions |