Need help creating a command button within a workbook (Book1) that will open
a different worksheet (Tab5) within the same workbook.

Place ANY piece of ClipArt on the worksheet. If you like buttons, make a
button using the rectangle from AutoShapes.

Right-click the Object and pick Assign Hyperlink.

Make the hyperlink to a place on Tab5
--
Gary''s Student - gsnu200830


"Priss" wrote:

Need help creating a command button within a workbook (Book1) that will open
a different worksheet (Tab5) within the same workbook.

Okay, I am working with Office 2007. I choose a command button, right click
and didn't see what you mentioned. I even tryed the ActiveX control as well.
I think I am just lost.

"Gary''s Student" wrote:

Place ANY piece of ClipArt on the worksheet. If you like buttons, make a
button using the rectangle from AutoShapes.

Right-click the Object and pick Assign Hyperlink.

Make the hyperlink to a place on Tab5
--
Gary''s Student - gsnu200830


"Priss" wrote:

Need help creating a command button within a workbook (Book1) that will open
a different worksheet (Tab5) within the same workbook.

O.K. Put this macro in a standard module:

Sub Macro3()
Application.Goto Reference:="Tab5!R[-8]C[-11]"
End Sub

If you have put a Forms button on the sheets, then right-click the button
and use Assign Macro

If you have put a Controls button the sheet, first click on Design mode,
then right-click the button and select View Code. Then insert the line:

Call Macro3

in the sub that appears
--
Gary''s Student - gsnu200830


"Priss" wrote:

Okay, I am working with Office 2007. I choose a command button, right click
and didn't see what you mentioned. I even tryed the ActiveX control as well.
I think I am just lost.

"Gary''s Student" wrote:

Place ANY piece of ClipArt on the worksheet. If you like buttons, make a
button using the rectangle from AutoShapes.

Right-click the Object and pick Assign Hyperlink.

Make the hyperlink to a place on Tab5
--
Gary''s Student - gsnu200830


"Priss" wrote:

Need help creating a command button within a workbook (Book1) that will open
a different worksheet (Tab5) within the same workbook.

Okay, I know it's user error and I am not that familiar. It may have
something to do with the way I am explaining too. But my workbook has (7)
worksheets - tab 1-7. One of those worksheets have names on it. When the
individual click there command button, I want it to go to that particular
worksheet which is for them ONLY. Not sure if this helped.

"Gary''s Student" wrote:

O.K. Put this macro in a standard module:

Sub Macro3()
Application.Goto Reference:="Tab5!R[-8]C[-11]"
End Sub

If you have put a Forms button on the sheets, then right-click the button
and use Assign Macro

If you have put a Controls button the sheet, first click on Design mode,
then right-click the button and select View Code. Then insert the line:

Call Macro3

in the sub that appears
--
Gary''s Student - gsnu200830


"Priss" wrote:

Okay, I am working with Office 2007. I choose a command button, right click
and didn't see what you mentioned. I even tryed the ActiveX control as well.
I think I am just lost.

"Gary''s Student" wrote:

Place ANY piece of ClipArt on the worksheet. If you like buttons, make a
button using the rectangle from AutoShapes.

Right-click the Object and pick Assign Hyperlink.

Make the hyperlink to a place on Tab5
--
Gary''s Student - gsnu200830


"Priss" wrote:

Need help creating a command button within a workbook (Book1) that will open
a different worksheet (Tab5) within the same workbook.

What is the name of the worksheet (tabname) that you want to jump to??

Is it Sheet5 or Tab5 ??

I am refering to the name on the worksheet tab at the bottom of the Excel
window.
--
Gary''s Student - gsnu200830


"Priss" wrote:

Okay, I know it's user error and I am not that familiar. It may have
something to do with the way I am explaining too. But my workbook has (7)
worksheets - tab 1-7. One of those worksheets have names on it. When the
individual click there command button, I want it to go to that particular
worksheet which is for them ONLY. Not sure if this helped.

"Gary''s Student" wrote:

O.K. Put this macro in a standard module:

Sub Macro3()
Application.Goto Reference:="Tab5!R[-8]C[-11]"
End Sub

If you have put a Forms button on the sheets, then right-click the button
and use Assign Macro

If you have put a Controls button the sheet, first click on Design mode,
then right-click the button and select View Code. Then insert the line:

Call Macro3

in the sub that appears
--
Gary''s Student - gsnu200830


"Priss" wrote:

Okay, I am working with Office 2007. I choose a command button, right click
and didn't see what you mentioned. I even tryed the ActiveX control as well.
I think I am just lost.

"Gary''s Student" wrote:

Place ANY piece of ClipArt on the worksheet. If you like buttons, make a
button using the rectangle from AutoShapes.

Right-click the Object and pick Assign Hyperlink.

Make the hyperlink to a place on Tab5
--
Gary''s Student - gsnu200830


"Priss" wrote:

Need help creating a command button within a workbook (Book1) that will open
a different worksheet (Tab5) within the same workbook.