How to move from one Worksheet to another.

D

Don J

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

--------------------------------------------------------
 
J

JE McGimpsey

One way:

Select a cell. Choose Insert/Hyperlink...

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

Chad

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
 
Top