Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have made a rather graphic interface for one of my models and in this
interface a use a lot of shapes, some of which I use as buttons. The problem is that excel redraws all the shapes, even when for instants only one or two shapes change color. This causes excel to run very slow, resulting in about 0,5 sec of redraw time, every time you push a button. I have tried: Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Application.EnableEvents = False My question: how can I use a large amount of shapes without excel slowing down? I am using Excel 2003. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) | |||
How can i get more 3D shapes for Auto shapes in excel? | Excel Discussion (Misc queries) |