View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Link to Worksheets

You can either use the HYPERLINK function (lots of examples in XL help file)
or you can insert a hyperlink (Ctrl+K) and using the diplay box, select
"place in this document" and then choose where you want to link to, and what
to display.

The two features work the same, HYPERLINK has the advantage in that's its
slightly easier to change, and you can perform a Find&Replace if needed.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Larry L" wrote:

I have developed an Excel file that has several Worksheets. I would like
develop a Cover Worksheet that has boxes that when clicked on will take you
to one of 4 worksheets that the users will use enter data.