cogswel__cogs
Board Regular
- Joined
- Jan 3, 2018
- Messages
- 180
I am working with two workbooks. Pulling data from one that the user is working in to another that is summarizing.
The second will be issued later.
It set up so when user opens book he goes to the one he is working in and runs a macro fort the new workbook.
It works fine but blinks between workbooks as it compiles.
I usually use application.screenupdating = false to speed up and keep viewer from being annoyed by macro running.
Is there something similar when working with multiple workbooks?
Any help is greatly appreciated
The second will be issued later.
It set up so when user opens book he goes to the one he is working in and runs a macro fort the new workbook.
It works fine but blinks between workbooks as it compiles.
I usually use application.screenupdating = false to speed up and keep viewer from being annoyed by macro running.
Is there something similar when working with multiple workbooks?
Any help is greatly appreciated