| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
screen updating
Sorry to ask all you smart people such a dumbass question
but at least it'll be easy to answer. What's the command that stops all the actions your macro is performing from happening 'live' on the screen? Instead all you see is the start point and endpoint, and it really speeds things up. I'm in a bit of a VB desert here, so I'd be grateful for help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
screen updating
To turn screen updating off - Application.ScreenUpdating = False and to turn it back on - Application.ScreenUpdating = True. Enjoy -- SeanEvan ----------------------------------------------------------------------- SeanEvans's Profile: http://www.excelforum.com/member.php...fo&userid=1465 View this thread: http://www.excelforum.com/showthread.php?threadid=26458 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
screen updating
thanks Sean
-----Original Message----- To turn screen updating off - Application.ScreenUpdating = False and to turn it back on - Application.ScreenUpdating = True. Enjoy ! -- SeanEvans ---------------------------------------------------------- -------------- SeanEvans's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=14650 View this thread: http://www.excelforum.com/showthread...hreadid=264583 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
screen updating
Application.ScreenUpdating = False
.... do your stuf Application.ScreenUpdating = True -- HTH RP "Josie" wrote in message ... Sorry to ask all you smart people such a dumbass question but at least it'll be easy to answer. What's the command that stops all the actions your macro is performing from happening 'live' on the screen? Instead all you see is the start point and endpoint, and it really speeds things up. I'm in a bit of a VB desert here, so I'd be grateful for help. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
screen updating
thanks Bob, there's another one for ya...
-----Original Message----- To turn screen updating off - Application.ScreenUpdating = False and to turn it back on - Application.ScreenUpdating = True. Enjoy ! -- SeanEvans ---------------------------------------------------------- -------------- SeanEvans's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=14650 View this thread: http://www.excelforum.com/showthread...hreadid=264583 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SCREEN NOT UPDATING | Excel Worksheet Functions | |||
| Screen updating | Charts and Charting in Excel | |||
| Screen updating | Excel Programming | |||
| Screen updating | Excel Programming | |||
| Screen Updating | Excel Programming | |||
Linear Mode
