Show named ranges names in gray in worksheet?

[STINE]

Hi

This is maby easier to explain with a small exampel:

I select A1:D30 in my workwheet and give this range the name TEST

If I zoom to below 30 percent in my worksheet, the named range is shown in gray letters in the worksheet.

Is it possible to see this also at 100 percent zoom?

I have a lot of named ranges in my worksheet and it would be a great help for the user if all named ranges in the sheet were vissible.
I have tried to search a lot of forums but cannot find any answer to this... Is there somebody inhere that might be able to help?

Best regards
Stine

 

[Andrew Poulsom]

Welcome to the Board.

For me it happens with a zoom below 40% (Excel 2000). Sorry, it's not possible to change that behaviour.

 

[VoG]

Maybe you can adapt the code here http://www.mrexcel.com/forum/showthread.php?t=426379