Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting non-linked cells in a linked worksheet | Excel Discussion (Misc queries) | |||
Setting up Treasure Hunt spreadsheet | Excel Discussion (Misc queries) | |||
VBA Code; need linked cells to change color if condition met | Excel Worksheet Functions | |||
VBE Expert Help, Code linked to Cells | Excel Worksheet Functions | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions |