Don't display the range name when zooming

[PeteB]

To display a certain block of 10000 cells in my spreadsheet I have set zoom to 25% and fiddled with column and row dimensions so that I have a square which will show a random pattern of red and white dots. All this is perfect, but the I have defined a name (decay_range) for the block and at this magnification it appears in large letters over my range. I can see the use of this but it distracts the eye from the pattern. Is there an option for removing this without giving up the convenience of using a named range

Thanks for any suggestions Pete

 

[Colo]

Hi PeteB,
Unfortunately there is no option for hiding this. It's Excel's speciation.
It would be displayed in case Zoom is set less than 40%.
(As far as I know, I'll post if there is a way.)

 

[Tom Urtis]

The problem is, there is no "Zoom event", so the image of the named range on the sheet at 39% zoom or less is unavoidable, unless someone has found a way to circumvent that, which if so I'd like to see it.

 

[Tom Urtis]

Thinking more about this, if you run this macro then the named range ("decay_range" in your case) will be invisible:

Sub Test1()
Dim nName As Name
For Each nName In Names
If Not nName.Name Like nName.Parent.Name & "!decay_range" Then nName.Visible = False
Next nName
End Sub


The problem is, it stays that way until you run another macro to set its visible property to True. Zooming above 39% will not do that by itself.

Maybe an option though.

 

[PeteB]

Thanks to Colo and Tom Urtis for their comments. I ran Tom's code and it more or less does what I need. However the fact that you both pointed out 39% was a threshold above which the name of the range would not appear was even more useful as I've been able to shrink the cell dimensions just enough to get away with 40% magnification and still see other useful things on the screen.

The board has been very helpful with this little idea of mine about modelling radioactive decay and half lives and I was able to use the finished spreadsheet in a successful lesson today, so thanks very much to all concerned. Pete

 

[DaveU]

Tom, just found this, really helpful. Thanks.