How to move from one Worksheet to another.

  • Thread starter Thread starter Don J
  • Start date Start date
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

--------------------------------------------------------
 
One way:

Select a cell. Choose Insert/Hyperlink...

Link To: #Sheet2!A1
Display: Go to Sheet2, cell A1
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Move or Copy Stopped Working? 0
command buttons disappear when I move worksheet 2007 1
Move/Copy Worksheet with Macros 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How do I transfer data from one worksheet to another? (Excel 2003) 0
move rows to another worksheet 1
Excel Moving data to sheet2 from sheet1 0

Back
Top