this is what i currently have, 

```
Dim mastertemp As Workbook
Dim testproject As Workbook

Set testproject = Workbooks("C:\Users\zzz\Documents\Test Project.xlsm")
Set mastertemp = Workbooks("C:\Users\zzz\Documents\MasterTemp.xlsx")

mastersheet.sheets("Sheet1").activate

```

the third line of code is giving me subscript out of range, any ideas?

I want to be able to jump between workbooks without the system giving me "workbook is already open, reopening would discard all changes etc"