View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Hageman Phil Hageman is offline
external usenet poster
 
Posts: 80
Default Code to Hunt Linked Cells

This is an ongoing thread that I have updated (changed my
idea...).

Want to put code in my "Personal Macro Workbook", attach
it to a menu button: when user clicks the button, all
cells in the active worksheet having links to other cells
(wherever located) are highlighted. An alternative could
be to make a list. If the cell already has a background
color, could the background color be restored upon
clicking the same button, or a second button. If not, can
exit without a save.

The objective is to know where all links are at a single
glance - with the click of a menu button.

Any suggestions to do this more effectively is appreciated.

Thanks, Phil