Command Button in Excel 2007 Chart

G

Gee

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
 
D

Dave Peterson

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.)
 
G

Gee

Ah, but I did use the command button from the toolbox toolbar!
I tried to assign a macro and I can't even get that on a right click. I
right click the button and it gives me choices for the whole chart, not the
button.
It just sits there, like it's in design mode, whether it's in decign mode or
not.
 
G

Gee

NO, wait, I pasted one from another spreadsheet...I tried again and it is
working now, Thanks, Mr. Peterson!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top