Andrew,

Only 1 workbook is open. It has a Sheet8. And this macro does not work
either:

Sub ActvateWorksheet()
'Activate worksheet
Workbooks("WT_Functions_2009.xls").Activate
Worksheets("Sheet8").Activate
End Sub

Thank you for your help,
Frankie