Hi,

Thanks everyone for your help.

I created a new workbook and the macro below works great. Now I'm
going to troubleshoot my existing workbook and find out why it will
not activate the worksheets.

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


Thanks,
jfcby