Hello,
I have buttons in a spreadsheet that let the user go right to a particular
chart.
Each chart has it's own sheet.
I need a button to go back to the spreadsheet called "INDEX".
I had done this in Excel 2003 no problem...just stuck a button on the chart
and

Private Sub CommandButton1_Click()
Sheets("INDEX").Select
End Sub

It will not work in 2007.
It won't even let me get at the button once I've pasted it in.
What am I doing wrong?
Thank you in advance for any help you can give me.
Gee