| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
supress screen refresh when macros running in excel VB
I want to supress the screen refresh/output while running VB macros in Excel.
There seems to be nothing in the help file to explain how to do it. I assume it is there as it was in Quattro years ago before Excel was popular. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
supress screen refresh when macros running in excel VB
Application.ScreenUpdating = False
' code that changes screen Application.ScreenUpdating = True -- Regards, Tom Ogilvy "drstraw" wrote in message ... I want to supress the screen refresh/output while running VB macros in Excel. There seems to be nothing in the help file to explain how to do it. I assume it is there as it was in Quattro years ago before Excel was popular. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
supress screen refresh when macros running in excel VB
Thanks! So easy once it is pointed out! So hard to find in the help system!
"Tom Ogilvy" wrote: Application.ScreenUpdating = False ' code that changes screen Application.ScreenUpdating = True -- Regards, Tom Ogilvy "drstraw" wrote in message ... I want to supress the screen refresh/output while running VB macros in Excel. There seems to be nothing in the help file to explain how to do it. I assume it is there as it was in Quattro years ago before Excel was popular. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
supress screen refresh when macros running in excel VB
Enter the word Screen in the Help search box in Excel 2003 ... 3rd listing
Enter the word Screen in the Answer Wizard box in Excel 2000 Visual Basic Help - 10th listing I think Microsoft did a reasonably good job making it available ;-) "drstraw" wrote in message ... Thanks! So easy once it is pointed out! So hard to find in the help system! "Tom Ogilvy" wrote: Application.ScreenUpdating = False ' code that changes screen Application.ScreenUpdating = True -- Regards, Tom Ogilvy "drstraw" wrote in message ... I want to supress the screen refresh/output while running VB macros in Excel. There seems to be nothing in the help file to explain how to do it. I assume it is there as it was in Quattro years ago before Excel was popular. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL 2007 CHART REFRESH WHILE MACRO IS RUNNING | Charts and Charting in Excel | |||
| Excel Screen Refresh Issue in Terminal Server | Excel Discussion (Misc queries) | |||
| Screen flash while running macros | Excel Discussion (Misc queries) | |||
| Supress Query Refresh dialog on opening workbook | Excel Programming | |||
| running a macro on every refresh of the screen | Excel Programming | |||
Linear Mode
