Gurus,

I am trying to handle an error when opening workbook "Bi-Weekly Payroll worksheet" (BWPR) from workbook "Timesheet"(TS).



In workbook "BWPR" there are worksheets titled with employee names. If there is not a worksheet with a name (specified in workbook "TS"), I want to open a different worksheet in workbook "BWPR". but its not working.

I get Run-time error"9"
Subscript out of range

Also, can I call a macro from TS that is in BWPR? Last line? I thought I could since the active sheet is BWPR


 Windows("Bi-Weekly Payroll worksheet.xlsm").Activate
    
On Error GoTo Err
    Sheets(Name).Select   'If worksheets(Name) is not created then ERR

Err:

Sheets(Employees).Select
 'Call Employee_Names
TIA,
Tim