| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freeze Worksheet while macro runs
Can somebody tell how to freeze a worksheet while a macro runs to
eliminate the sheet jumping around? Thanks DLS *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Freeze Worksheet while macro runs
Hello,
Application.ScreenUpdating = False will fix your problem. When the macro is done executing, you should type Application.ScreenUpdating = True to turn it back on. -----Original Message----- Can somebody tell how to freeze a worksheet while a macro runs to eliminate the sheet jumping around? Thanks DLS *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Freeze Worksheet while macro runs
Hi
use application.screenupdating=false 'your code application.screenupdating=true in additon you may remove all select/activate statements but use object references instead -- Regards Frank Kabel Frankfurt, Germany <DLS schrieb im Newsbeitrag ... Can somebody tell how to freeze a worksheet while a macro runs to eliminate the sheet jumping around? Thanks DLS *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
| Macro that runs when worksheet is automatically updated | Excel Worksheet Functions | |||
| One macro runs then it auto runs another macro | Excel Discussion (Misc queries) | |||
| Which Macro Runs...? | Excel Discussion (Misc queries) | |||
| VBA code that only runs when a worksheet is active | Excel Programming | |||
![DLS[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
