View Single Post
  #12  
Old March 2nd, 2006, 02:34 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default Insert Picture from dropdown selection


Hello Jufa

As I mentioned above, I'm not an expert in VBA but if you add a line to
the code shown on the McGimpsey site you can retain your logo.

Try this:

Private Sub Worksheet_Calculate()
Dim oPic As Picture
Me.Pictures.Visible = False
ActiveSheet.Shapes("Picture 8").Visible = True
With Range("F1")
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

Notice the added line: ActiveSheet.Shapes("Picture 8").Visible = True
(You could add additional lines right after it for other pictures you
want retained)

This will keep Picture 8 visible at all times so add that line to your
code and use the name of your logo instead of Picture 8


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=513797