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.