Jan Karel Pieterse (
http://jkp-ads.com) has developed a custom Name
Manager that gives you much more control over names than Excel's
built-in name manager. It allows you to hide names from appearing in the
Name Box or in Excel's Name Manager.
- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/
Stanley wrote:
Hi,
I have a spreadsheet which other people use, but I don't want them to see
the cell names I have used. Is there any way to hide the Name Box on the
screen, and stop access to the Name Manager ? I thought protecting the sheet
and workbook would do this, but it doesn't seem to.
Thanks very much.