Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show range names in background
When you have range names in a worksheet and you set the zoom lower than 40%,
all range names appear in the background with borders around it. Is there a way to show range names in the background in the same manner but with a more user friendly zoom llike 75% or 100%? I searched a lot on the web and all I found is the follwing: Excel name manager highlights range names but it does not allow you to click in the cells behing the range name. When you do so, you are in a text box containing the range name, not in the cell. I also found VBA functions that can be used with conditional formating. Those functions scan all names in the workbook to test if the conditional formated cell intercepts a range address. It works but since every single names are scan in every single cell where the conditional formating is applied, this method is not really efficient in large workbooks. Any other suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
How do I get drop down menu's to show different background colour | Excel Discussion (Misc queries) | |||
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
When zoomed out, How do I NOT show range names? | Excel Discussion (Misc queries) | |||
How do I make background color show up in my document instead of . | Excel Discussion (Misc queries) |