How to move from one Worksheet to another.
 

I've done this before, but cannot find it in either help or any excel
manual. What I would like to do is to embed a command in a Worksheet that
when clicked will take me to another Worksheet in the same Workbook

Don

--------------------------------------------------------

How to move from one Worksheet to another.
 

hyperlink
--
Gary''s Student
gsnu200707


"Don J" wrote:

I've done this before, but cannot find it in either help or any excel
manual. What I would like to do is to embed a command in a Worksheet that
when clicked will take me to another Worksheet in the same Workbook

Don

--------------------------------------------------------

How to move from one Worksheet to another.
 

One way:

Select a cell. Choose Insert/Hyperlink...

Link To: #Sheet2!A1
Display: Go to Sheet2, cell A1



In article ,
"Don J" wrote:

I've done this before, but cannot find it in either help or any excel
manual. What I would like to do is to embed a command in a Worksheet that
when clicked will take me to another Worksheet in the same Workbook

Don

--------------------------------------------------------

How to move from one Worksheet to another.
 

If you're talking about using a button to move to another sheet, after
creating the button, make the referenced code read sheets("Sheet2").select,
utilizing whatever sheet you would like to select. Hope this helps!

-Chad

"Don J" wrote:

I've done this before, but cannot find it in either help or any excel
manual. What I would like to do is to embed a command in a Worksheet that
when clicked will take me to another Worksheet in the same Workbook

Don

--------------------------------------------------------