VBA Worksheet.Move Question

[KarlGramith]

I have a Workbook called "Workbook1" that contains a number of data sheets.

Workbook1 contains a subroutine that produces a report consisting of 40 worksheets, produced one sheet at a time.

After each report worksheet is produced in Workbook1 it is moved by the subroutine to a report workbook called "Workbook2".

Everything works fine with the exception that every time each of the 40 report worksheets is moved to Workbook2, Workbook2 is activated and I need to reactivate Workbook1 to continue with the VBA code execution.

This rapid switching between active workbooks causes the computer monitor to flicker back and forth between displaying the active worksheet in Workbook1 and the active worksheet in Workbook2. This is not good from the user experience perspective.

Is there a way in excel VBA to move worksheets from one workbook to a second workbook without activating the second workbook? Any other solutions to this problem???


Thanks for any info. Karl

[ChristopherBrandonKi]

if you are worried about the flickering, one thing you could do is put

Please Login or Register  to view this content.

At the beginning of your code.

It would speed up your code as well as keep the "flickering" from happening.

As for the avoiding activating different workbooks, Someone with more experience may be able to help with that. I know you can with worksheets but I am not certain with workbooks.

[ChristopherBrandonKi]

wait, you have to manually click workbook one with your mouse to continue the code execution?