View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
areaume
 
Posts: n/a
Default Macro linked to text or an object

I have a single page in Excel that is formattted to be a series of objects
(boxes) at the top of the page that will take you to selected text lower in
the page. I need a macro that will take me to the selected text and will
remain with that text even if additional rows are inserted above it.

I tried creating a object next to my text and linking the macro to it. The
object will move with the text but I cannot get the macro to "go to" the
object, it only moves to that cell. Once more data is inserted above it, the
macro take me to the original cell rather than moving with my text.

Thank-you for any help you can offer.