H
H.G. Lamy
Hello,
can defined names be hidden so as to prevent accidental deletion ?
Regards,
hgl
can defined names be hidden so as to prevent accidental deletion ?
Regards,
hgl
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jacob Skaria
Refer the below site for a custom Name Manager that gives you better control
over names and can hide them from displaying.
http://jkp-ads.com
over names and can hide them from displaying.
http://jkp-ads.com
B
Bob Phillips
Yes they can. In VBA use
Activeworkbook.Names("myName").Hidden = True
But I agree with Jacob, get NameManager, it is the best addin available to
Excel, and it is free!
HTH
Bob
Activeworkbook.Names("myName").Hidden = True
But I agree with Jacob, get NameManager, it is the best addin available to
Excel, and it is free!
HTH
Bob
H
H.G. Lamy
Thank you.
I've heard about J's Name Manager, but was concerned about too much
'overhead' in memory.
"Hidden" as suggested I've tried, but doesn't seem to exist (in my XL 2003
version), but apparently "visible" does the trick.
Regards,
hgl
I've heard about J's Name Manager, but was concerned about too much
'overhead' in memory.
"Hidden" as suggested I've tried, but doesn't seem to exist (in my XL 2003
version), but apparently "visible" does the trick.
Regards,
hgl
B
Bob Phillips
Sorry, wrong property name. I have never understood why MS use Hidden in
some context, visible in others. Consistent it ain't!
As to NameManager, it has a small enough footprint. It is the one addin I
would not be without, I would even pay for it if I had to.
Bob
some context, visible in others. Consistent it ain't!
As to NameManager, it has a small enough footprint. It is the one addin I
would not be without, I would even pay for it if I had to.
Bob
D
Dave Peterson
You don't have to load the name manager each time you use excel.
I keep a copy in my utilities folder and only open it when I need it.
I keep a copy in my utilities folder and only open it when I need it.
H
H.G. Lamy
Recommendation appreciated,
hgl
hgl
Dave Peterson said:You don't have to load the name manager each time you use excel.
I keep a copy in my utilities folder and only open it when I need it.