Macro to prevent switching ActiveBook

[savio21]

Hi All,

I have the following code in a UserForm to copy a range of cells and paste it into a new workbook.

    
Sheets("YoYMats").Select
    Range("a1:s25").Select
    Selection.Copy
    Workbooks.Add
    ActiveSheet.Paste

Unfrotunately, when I do this it makes the new workbook the Active Workbook and the above code fails when it is run a second time. I should also note, I do not want the user to see the workbook behind the UserForm. My current solution to the above problem was to add this code after the paste:

Windows("GHG Calculator NM v3.xlsm").Activate

This works well until the user saves the file as another name, then the code fails and i need to manually go in and update it. Is there a way for me to set the workbook with the macros as always the ActiveWorkbook?

Thanks in advance for your help.