Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have an application that builds a grid map and draws lots of lines between cells. The number of lines is currently over 600 but could grow more and each line contains a hyperlink and screentip text. The app works reasonably fast for the first 3-400 lines but exponentially slows to a crawl. By the end it could be a line per second or slower. I've seen recommendations not to use the "selection." command but I can't figure out how to use it for my application. Below is the code that works. If I try to use LineShape.Hyperlinks.... I get an error. I've also noticed that excel shows each line plotting even though I have sreenupdating off.... am I missing something on that? Thanks, MikeZz Set LineShape = ActiveSheet.Shapes.AddLine(x1, y1, x2, y2) LineShape.Select ActiveSheet.Hyperlinks.Add Anchor:=Selection.ShapeRange.Item(lineName), _ Address:= "", SubAddress:=linkAdd, ScreenTip:=screenTipText |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lots of REM lines an easy way? | Excel Programming | |||
VBA to draw lines of SPC | Charts and Charting in Excel | |||
Can I line up lots of controls on a sheet at once? | Excel Programming | |||
How do I draw lines..?? | Excel Programming | |||
Slow Draw with Excel VBA 2000 | Excel Programming |