H H.G. Lamy Feb 5, 2010 #1 Hello, can defined names be hidden so as to prevent accidental deletion ? Regards, hgl
J Jacob Skaria Feb 5, 2010 #2 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
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
B Bob Phillips Feb 5, 2010 #3 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
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
H H.G. Lamy Feb 5, 2010 #4 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
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
B Bob Phillips Feb 5, 2010 #5 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
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
D Dave Peterson Feb 5, 2010 #6 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.
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.
H H.G. Lamy Feb 5, 2010 #7 Recommendation appreciated, 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. Click to expand...
Recommendation appreciated, 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. Click to expand...
