Hi Steve

three ideas
1) you don't have a sheet called Sheet1
2) macros are not enabled (tools / macro /security - set to medium - choose
enable macros when asked)
3) it's not in the ThisWorkbook module of the workbook

Cheers
JulieD

"Steve" wrote in message
...
Can anyone tell me why this isn't working?

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
End Sub