Dear Anybody.

During recording a Macro, I have copied and pasted from different files and
sheets. In doing this, I have clicked on the files and sheets needed.
When the recorded Macro is running, it is maximizing the files needed
(considering they are open). This shows a lot of switching between windows
which is not needed.
- Can the window switching be disabled when the files are being accessed? How?
- Can the files be accessed even when they are closed? How?
Is there a way of adding a single command at the beginning of the macro to
do any of the things mentioned above?


Thanks in Advance.