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?

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