have you tried to put a ThisWorkbook.Activate before the wkb_main.Sheets("Index").Select ?