Hi Gary,
Thx, this works fine. Exactly what i was looking for.
thx Again
Hi Norman,
I do have that add-in you mentioned. I wanted a code i could run to
hide/unhide names,
as not all the computers i work on, have the add-in. Hence if i hide
them at home, then
take the file to work i may need to unhide them.
I can run this from the VBE, without anyone knowing its there.
Thx for your input.
Dave
Gary Keramidas Wrote:
try this
Option Explicit
Dim nm As name
Sub hide_names()
For Each nm In ThisWorkbook.Names
nm.Visible = False
Next nm
End Sub
--
Gary
"Desert Piranha"
<Desert.Piranha.1znoum_1133935803.2303@excelforu m-nospam.com wrote in
message
news:Desert.Piranha.1znoum_1133935803.2303@excelfo rum-nospam.com...
Hi all,
While this code works fine for creating & hiding one defined name.
How can i change it to hide ALL defined names in the workbook,
if there are 20/30 of them, that already exist.
Public Sub Tester03()
'From Norman Jones
With ActiveWorkbook
Names.Add "MyTestRange", _
RefersTo:=.Sheets("Sheet1").Range("A4:B10"), _
Visible:=False
End With
End Sub
Something like:
Public Sub Tester03()
With ActiveWorkbook
Names.Visible:=False
End With
End Sub
--
Desert Piranha
------------------------------------------------------------------------
Desert Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=28934
View this thread:
http://www.excelforum.com/showthread...hreadid=491357
--
Desert Piranha
------------------------------------------------------------------------
Desert Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=28934
View this thread:
http://www.excelforum.com/showthread...hreadid=491357