If their value is produced by a linking formula linked to the source data,
you can go into tools=options, edit mode and unselect Edit directly in a
cell. Then if you double click on the cell, you will be taken to the cell
it is linked to. No coding required. Editing is then done in the formula
bar.

--
Regards,
Tom Ogilvy

"robboll" wrote in message
ups.com...
Is there a simple way to code a link on an Excel workbook so that when
you click on it, it takes you to a specific cell in the workbook?

For example. At the top of the spreadsheet you have a number of parts:

Part #1
Part #2
Part #3

I can easily make them links -- but what is the code that I need so
when I click on Part #2 it takes be to a cell on the workbook (e.g.,
Cell A1827) where the user finds related information about it?

Thanks for any assistance with this!

RBollinger