Thanks for the reply.
This doesnt stop the Name Box being on the screen with the drop-down list of
all names in the workbook, and the Name Manager can still be accessed and
this also shows all names in the workbook, even those in locked and hidden
cells.
Cheers.

"Ms-Exl-Learner" wrote:

Just select the cells for which you have applied the formula and do right
clickFormat CellsProtectionTick Both Locked & Hidden Check boxes and
give ok.

Unlock all the cells which ever you want the people to have access as
mentioned below:

Select the Columns Or Cells that needs to have the Editing option and do
right clickFormat CellsProtectionUncheck Both the Locked & Hidden Check
boxes and give ok.

Now Protect the worksheet with a password.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"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.