From: Johanna Gronlund on
Hello,

I have a command button (Button 4585). I would like it to take the user to
another place (cells A147:A180) on the same sheet (Sheet 10). Is this
possible? I cannot just use a hyperlink on a cell as the button only becomes
visible if the user makes certain choices.

Thanks very much in advance.

Johanna

From: Jason Falzon on
Try attaching this macro

Sub Button4585_Click()

Sheets("Sheet10").Activate
'Range("A147").Select 'this will go to A147
Range("A147:A180").Select 'this will HIGHLIGHT range

End Sub


Choose one of the Range() lines only remove ' from Range("A147").select if
want to use that

Jason
"Johanna Gronlund" wrote:

> Hello,
>
> I have a command button (Button 4585). I would like it to take the user to
> another place (cells A147:A180) on the same sheet (Sheet 10). Is this
> possible? I cannot just use a hyperlink on a cell as the button only becomes
> visible if the user makes certain choices.
>
> Thanks very much in advance.
>
> Johanna
>
From: Jason Falzon on
Also in your case use


Sheets("Sheet 10").Activate

and not Sheet10 as your sheet name has a space.


Jason

"Jason Falzon" wrote:

> Try attaching this macro
>
> Sub Button4585_Click()
>
> Sheets("Sheet10").Activate
> 'Range("A147").Select 'this will go to A147
> Range("A147:A180").Select 'this will HIGHLIGHT range
>
> End Sub
>
>
> Choose one of the Range() lines only remove ' from Range("A147").select if
> want to use that
>
> Jason
> "Johanna Gronlund" wrote:
>
> > Hello,
> >
> > I have a command button (Button 4585). I would like it to take the user to
> > another place (cells A147:A180) on the same sheet (Sheet 10). Is this
> > possible? I cannot just use a hyperlink on a cell as the button only becomes
> > visible if the user makes certain choices.
> >
> > Thanks very much in advance.
> >
> > Johanna
> >
From: Johanna Gronlund on
Thanks, this was very useful and worked.

Johanna



"Jason Falzon" wrote:

> Also in your case use
>
>
> Sheets("Sheet 10").Activate
>
> and not Sheet10 as your sheet name has a space.
>
>
> Jason
>
> "Jason Falzon" wrote:
>
> > Try attaching this macro
> >
> > Sub Button4585_Click()
> >
> > Sheets("Sheet10").Activate
> > 'Range("A147").Select 'this will go to A147
> > Range("A147:A180").Select 'this will HIGHLIGHT range
> >
> > End Sub
> >
> >
> > Choose one of the Range() lines only remove ' from Range("A147").select if
> > want to use that
> >
> > Jason
> > "Johanna Gronlund" wrote:
> >
> > > Hello,
> > >
> > > I have a command button (Button 4585). I would like it to take the user to
> > > another place (cells A147:A180) on the same sheet (Sheet 10). Is this
> > > possible? I cannot just use a hyperlink on a cell as the button only becomes
> > > visible if the user makes certain choices.
> > >
> > > Thanks very much in advance.
> > >
> > > Johanna
> > >
From: Gord Dibben on
First give the range a name.

Insert>Name>Define myrng

Private Sub CommandButton1_Click()
Application.Goto Reference:="myrng"
End Sub


Gord Dibben MS Excel MVP

On Thu, 1 Apr 2010 00:41:01 -0700, Johanna Gronlund
<JohannaGronlund(a)discussions.microsoft.com> wrote:

>Hello,
>
>I have a command button (Button 4585). I would like it to take the user to
>another place (cells A147:A180) on the same sheet (Sheet 10). Is this
>possible? I cannot just use a hyperlink on a cell as the button only becomes
>visible if the user makes certain choices.
>
>Thanks very much in advance.
>
>Johanna