| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiding processes
Hello,
The macro i am working on has a number of processes that involve copying information from one file to the other. This causes the screen to 'flash' for a period of time. Is there any way to make some of these processes invisible. (I'm worried that this might confuse the people that will be running it) Thanks for your help. marta |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hiding processes
hi
use application.screenupdating=false 'your code application.screenupdating=True -- Regards Frank Kabel Frankfurt, Germany marta wrote: Hello, The macro i am working on has a number of processes that involve copying information from one file to the other. This causes the screen to 'flash' for a period of time. Is there any way to make some of these processes invisible. (I'm worried that this might confuse the people that will be running it) Thanks for your help. marta |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
hiding processes
Marta,
Set the ScreenUpdating property to False, run your code, and then restore it to True. E.g., Application.ScreenUpdating = False ' your code here Application.ScreenUpdating = True -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "marta" wrote in message ... Hello, The macro i am working on has a number of processes that involve copying information from one file to the other. This causes the screen to 'flash' for a period of time. Is there any way to make some of these processes invisible. (I'm worried that this might confuse the people that will be running it) Thanks for your help. marta |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Processes in one cell | Excel Discussion (Misc queries) | |||
| Preserving Text Only despite Excel's # Recognition Processes | Excel Discussion (Misc queries) | |||
| hiding | Excel Discussion (Misc queries) | |||
| Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
| HIDING DIV/0! | Excel Discussion (Misc queries) | |||
Linear Mode
