View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Drew[_7_] Drew[_7_] is offline
external usenet poster
 
Posts: 1
Default Internal Hyperlinks in toolbar

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.