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

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

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.



"Dave Peterson" wrote:

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

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

"Gee" wrote:

> 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.
>
>
>
> "Dave Peterson" wrote:
>
> > 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
> > .
> >