Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've built a picture display in excel using the (widely recommended) link:
http://mcgimpsey.com/excel/lookuppics.html It works superbly! But once I reach 60 pictures it generates a 1004 runtime error: "Unable to set the Visible property of the Pictures class". The code - supplied on the mcgimpsey site - doesn't suggest any limitations so I'm wondering if its an excel limit. Can anyone advise? I've copied the code below. Private Sub Worksheet_Calculate() Dim oPic As Picture Me.Pictures.Visible = False With Range("b5") 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 Once again, the mcgimpsey solution is first class, the problem is getting to the target 110 pictures. Many thanks David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you export pictures from my pictures file into a word docu | New Users to Excel | |||
Storing Clip Art pictures in My Pictures folder | Excel Discussion (Misc queries) | |||
Excel's Compress Pictures or deleting pictures doesn't seem work | Excel Discussion (Misc queries) | |||
I need help with pictures | Excel Discussion (Misc queries) | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) |