| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
visual basic code runs very slow in 2007
I created a procedure that checks the spreadsheet for any corruptions, it
took about 1-2 minutes to complete. In 2007 it takes over 8 minutes, while its running all the command buttons on the sheet flicker for some reason. Any ideas or do we go back to 2003 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
visual basic code runs very slow in 2007
For lots of reasons I don't use command buttons. I prefer shapes or forms
buttons. Maybe this is another reason not to. Change em or try application.screenupdating=false code application.screenupdating=true -- Don Guillett Microsoft MVP Excel SalesAid Software "kwtrash" wrote in message ... I created a procedure that checks the spreadsheet for any corruptions, it took about 1-2 minutes to complete. In 2007 it takes over 8 minutes, while its running all the command buttons on the sheet flicker for some reason. Any ideas or do we go back to 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| visual basic code in 2003 vs 2007 | Excel Discussion (Misc queries) | |||
| Very slow Visual Basic code execution in new Excel 2007 | Excel Programming | |||
| Excel macro in 2007 runs extremely slow | Excel Discussion (Misc queries) | |||
| Code runs to slow | Excel Programming | |||
Linear Mode
