Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Paste Names
In the same way that it is possible to hide macros from the UI by using the
Option Private Module statement, is it possible to hide names from the paste names box? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Paste Names
Hi Giles,
In the same way that it is possible to hide macros from the UI by using the Option Private Module statement, is it possible to hide names from the paste names box? Yes, by setting their visible property to false (using VBA), or alternatively, by downloading my free Name Manager: http://www.jkp-ads.com/officemarketplacenm-en.asp and using that to hide them. Of course anyone who reads this can still list all names using that utility <smile. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Names | Excel Discussion (Misc queries) | |||
How to hide column and row names | Excel Worksheet Functions | |||
Hide used names in drop downbox. | Excel Worksheet Functions | |||
Hide Defined Names | Excel Programming | |||
hide / unhide names | Excel Programming |