I bet you didn't use the commandbutton from the control toolbox toolbar in
xl2003.

Try using the Button from the Forms toolbar. You'll have to assign the macro
the button, too.

(Same as with xl2003.)

Gee wrote:

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

--

Dave Peterson