Paste this into the workbook code area:

Private Sub Workbook_Open()
Sheets("ChartName").Activate
End Sub

Make sure that:
1. You paste it into the workbook code window, not in a module.
2. Macros are set to run when workbook opens.




"gazza67" wrote:

Hi,

I have a workbook with many sheets. I can make any worksheet I want to
be the initial sheet to be opened when the document is opened, HOWEVER
I want to make a chart the initial sheet to open and I cant make this
work.

I am running excel2000

Cheers,
Gazza