LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting non-linked cells in a linked worksheet Gary Excel Discussion (Misc queries) 1 October 25th 08 03:38 AM
Setting up Treasure Hunt spreadsheet Rachael Excel Discussion (Misc queries) 11 September 13th 08 02:06 AM
VBA Code; need linked cells to change color if condition met JVANWORTH Excel Worksheet Functions 26 September 13th 07 01:01 PM
VBE Expert Help, Code linked to Cells JVANWORTH Excel Worksheet Functions 12 June 26th 07 07:00 AM
Linked Cells Staying With Cells Once Linked Workbook Update. [email protected] Excel Worksheet Functions 0 June 6th 06 09:32 AM


All times are GMT +1. The time now is 08:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"