Hello,
Can I stop the displaying of the name of the named area when I am zoomed out of a worksheet? I can not see an option on the Tools > Options > View menu.
[Edit]
A workaround, found by accident, is to make the named area have more than one area. However this is not always possible so I am still interested in an answer!
Thanks,
Alan.
Re: Stop The Display Of Names For Named Areas
I don't know of a way to do it manually, but the following VBA Procedure will hide all names in the workbook:
Sub Hide_Names()
Dim iName As Name
For Each iName In ThisWorkbook.Names
iName.Visible = False
Next iName
End Sub
To unhide them, change False to True.
Or you could hide the Formula bar:
Tools / Options / View
Mac
Re: Stop The Display Of Names For Named Areas
Thanks,
I will give that a go later!
A.
Re: Stop Display Of Names Of Named Ranges When Zooming
I'm not sure but I think zooming will display Hidden names as well.
Re: Stop Display Of Names Of Named Ranges When Zooming
The code solution works!
Thanks very much for the solution, I will store it a way and try and remember it....
The hiding of the formula bar did not work.
Thanks,
A.
Re: Stop Display Of Names Of Named Ranges When Zooming
Excel displays the Named Range when the zoom is less than 40%. (http://www.excelfunctions.net/Excel-Zoom.html) I haven't found any hack to change the 40% to 0% (which would stop displays on zooms).
Don’t have an account yet? Register yourself now and be a part of our community!