Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Linked pictures to cell dropdown

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to create a dropdown list with pictures/icons ? Tom Vandewiele Excel Discussion (Misc queries) 15 June 11th 20 11:26 PM
Pictures in dropdown lists Woody Excel Discussion (Misc queries) 4 August 14th 09 08:15 PM
Pictures in Dropdown Peter Excel Discussion (Misc queries) 4 December 2nd 08 08:41 AM
Multiple dropdown list with pictures Peter Excel Discussion (Misc queries) 0 November 28th 08 02:48 PM
Change sheet name on linked cell by dropdown box Mikeice Excel Worksheet Functions 12 June 11th 05 08:45 AM


All times are GMT +1. The time now is 04:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"