Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Declear which picture I want to show and not?!
Hi! Here is same code I have wrote: Private Sub Worksheet_Calculate() Dim oPic As Picture Me.Pictures.Visible = False With Range("B41") 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 Now all the pictures in the document get invisible! I want to declear which picture that should be visible or not. Ex. I want to make picture 1-11 visible = False. How? How do I decler that a specific picture should be visible, "Picture 101.Visible = True"? Thanks? -- petterss ------------------------------------------------------------------------ petterss's Profile: http://www.excelforum.com/member.php...o&userid=36354 View this thread: http://www.excelforum.com/showthread...hreadid=570682 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|