Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide defined names?
Hello,
can defined names be hidden so as to prevent accidental deletion ? Regards, hgl |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide defined names?
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 -- Jacob "H.G. Lamy" wrote: Hello, can defined names be hidden so as to prevent accidental deletion ? Regards, hgl . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide defined names?
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.G. Lamy" wrote in message ... Hello, can defined names be hidden so as to prevent accidental deletion ? Regards, hgl |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide defined names?
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 "Bob Phillips" wrote in message ... 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.G. Lamy" wrote in message ... Hello, can defined names be hidden so as to prevent accidental deletion ? Regards, hgl |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide defined names?
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 "H.G. Lamy" wrote in message ... 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 "Bob Phillips" wrote in message ... 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.G. Lamy" wrote in message ... Hello, can defined names be hidden so as to prevent accidental deletion ? Regards, hgl |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide defined names?
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.G. Lamy" wrote: 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 "Bob Phillips" wrote in message ... 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.G. Lamy" wrote in message ... Hello, can defined names be hidden so as to prevent accidental deletion ? Regards, hgl -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide defined names?
Recommendation appreciated,
hgl "Dave Peterson" wrote in message ... 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.G. Lamy" wrote: 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 "Bob Phillips" wrote in message ... 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.G. Lamy" wrote in message ... Hello, can defined names be hidden so as to prevent accidental deletion ? Regards, hgl -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why use defined names? | Excel Discussion (Misc queries) | |||
defined names | Excel Worksheet Functions | |||
Defined names | Excel Discussion (Misc queries) | |||
Hide Defined Names | Excel Programming | |||
Defined Names | Excel Programming |