I would like to create hyperlinks in my toolbar to jump to
named cells in an open Excel file.
I am working with estimates that are many pages long.
Each estimate has named cells at each division through out
the estimates. I would like to place internal hyperlinks
in the toolbar to jump to a specific named cell in an
estimate. I would like this to work for any estimate that
is open so creating hyperlinks within each estimate would
be time consuming and beyond what I would want the
estimators to do.
Is there a way to code a macro to jump to a named cell and
then I can assign that macro to a toolbar button?

I am not a professional programmer and have look all over
the web and some books and I can not find an answer to
this. It doesn't seem like it would be this difficult.

Thanks for any help you can offer.

Hi Drew,
You did not supply much to go on, obviously you want to go
to different named cells and those named cells probably contain
a division name. If your division name is on the active row then
you can concatenate that value in the name for your defined named.
I think you'd be better off with hyperlinks
in cells. Untested but like coding on
http://www.mvps.org/dmcritchie/excel/code/gotostuff.txt

Sub GoToHomeBase()
On Error GoTo NF
Application.Goto Range("homebase")
Exit Sub
NF:
MsgBox "GoToCell failed to find the ""homebase"" named cell"
End Sub

perhaps use this
Application.Goto Range("division_" & cells(activecell.row, 1).text
instead of
Application.Goto Range("homebase")

To assign your macro to a toolbar button see
http://www.mvps.org/dmcritchie/excel/toolbars.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Drew" wrote in message ...
I would like to create hyperlinks in my toolbar to jump to
named cells in an open Excel file.
I am working with estimates that are many pages long.
Each estimate has named cells at each division through out
the estimates. I would like to place internal hyperlinks
in the toolbar to jump to a specific named cell in an
estimate. I would like this to work for any estimate that
is open so creating hyperlinks within each estimate would
be time consuming and beyond what I would want the
estimators to do.
Is there a way to code a macro to jump to a named cell and
then I can assign that macro to a toolbar button?

I am not a professional programmer and have look all over
the web and some books and I can not find an answer to
this. It doesn't seem like it would be this difficult.

Thanks for any help you can offer.

Thank you for your help. I appololgize for not giving
more information. I see that I was not using the right
terminology for what I needed to do.

From your suggestion of the goto statement, I looked
around and found the following "select" statement which
appears to accomplish all that I need.
ActiveSheet.Range("SITEWORK").Select
"SITEWORK" is the name of the cell where I want to jump.

Thanks

-----Original Message-----
Hi Drew,
You did not supply much to go on, obviously you want to
go
to different named cells and those named cells probably
contain
a division name. If your division name is on the active
row then
you can concatenate that value in the name for your
defined named.
I think you'd be better off with hyperlinks
in cells. Untested but like coding on
http://www.mvps.org/dmcritchie/excel/code/gotostuff.txt

Sub GoToHomeBase()
On Error GoTo NF
Application.Goto Range("homebase")
Exit Sub
NF:
MsgBox "GoToCell failed to find the ""homebase"" named
cell"
End Sub

perhaps use this
Application.Goto Range("division_" & cells
(activecell.row, 1).text
instead of
Application.Goto Range("homebase")

To assign your macro to a toolbar button see
http://www.mvps.org/dmcritchie/excel/toolbars.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed
Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm

"Drew" wrote in message
...
I would like to create hyperlinks in my toolbar to jump
to
named cells in an open Excel file.
I am working with estimates that are many pages long.
Each estimate has named cells at each division through
out
the estimates. I would like to place internal
hyperlinks
in the toolbar to jump to a specific named cell in an
estimate. I would like this to work for any estimate
that
is open so creating hyperlinks within each estimate
would
be time consuming and beyond what I would want the
estimators to do.
Is there a way to code a macro to jump to a named cell
and
then I can assign that macro to a toolbar button?

I am not a professional programmer and have look all
over
the web and some books and I can not find an answer to
this. It doesn't seem like it would be this difficult.

Thanks for any help you can offer.



.

Hi Drew,
Okay I certainly wasn't expecting you meant in the same worksheet.
Glad you figured it out, AND supplied the answer you were looking for.
Building pieces together is what makes the newsgroups so great
along with the search engines to find more examples.
---
David McRitchie,

"drew" wrote in message ...
Thank you for your help. I appololgize for not giving
more information. I see that I was not using the right
terminology for what I needed to do.