keep thisworkbook as the workbook that is displayed after macro is finished running

[user125]

Hi all,

I have created a code that copies data from one workbook (Workbook1) and pastes it into another workbook (Worbook2). The code works fine but after it is finished, it displays Workbook2 on the computer screen. I would like Workbook1 to be the workbook that shows up after the code is done running. The code is in Workbook1 as well. I have tried various lines of code but I have not achienved what I am looking for. Any help would be appreciated! Thanks in advance! and hope everyone is staying safe!

 

[GWteB]

Moving the code worked perfectly. That was such an easy fix! Thank you!

You are welcome & thanks for letting us know.