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.

excel 2003
one way might be to set your own password for file opening
if not matched the Workbook_Open event would delete the Formula
toolbar

Private Sub Workbook_Open()
Application.DisplayFormulaBar = True
k = InputBox("Insert a password")
If k < "your_password" Then Application.DisplayFormulaBar = False
End Sub

pls click YES if it helped


On 6 Lis, 12:16, 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.

Private Sub Workbook_Open()
Application.DisplayFormulaBar = True
If InputBox("Insert a password") < "your_password" Then
Application.DisplayFormulaBar = False
End Sub

is even simpler


On 6 Lis, 12:37, Jarek Kujawa wrote:
excel 2003
one way might be to set your own password for file opening
if not matched the Workbook_Open event would delete the Formula
toolbar

Private Sub Workbook_Open()
Application.DisplayFormulaBar = True
k = InputBox("Insert a password")
If k < "your_password" Then Application.DisplayFormulaBar = False
End Sub

pls click YES if it helped

On 6 Lis, 12:16, 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.- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -

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.

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.

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.

Hi Stanley,

Did you ever figure out a way to do this?

Thanks
Sid

On Friday, November 6, 2009 2:20:05 PM UTC, Stanley wrote:
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.

&quot;Ms-Exl-Learner&quot; wrote:

&gt; Just select the cells for which you have applied the formula and do right
&gt; click&gt;&gt;Format Cells&gt;&gt;Protection&gt;&gt;Tick Both Locked &amp; Hidden Check boxes and
&gt; give ok.
&gt;
&gt; Unlock all the cells which ever you want the people to have access as
&gt; mentioned below:
&gt;
&gt; Select the Columns Or Cells that needs to have the Editing option and do
&gt; right click&gt;&gt;Format Cells&gt;&gt;Protection&gt;&gt;Uncheck Both the Locked &amp; Hidden Check
&gt; boxes and give ok.
&gt;
&gt; Now Protect the worksheet with a password.
&gt;
&gt; If this post helps, Click Yes!
&gt;
&gt; --------------------
&gt; (Ms-Exl-Learner)
&gt; --------------------
&gt;
&gt;
&gt;
&gt; &quot;Stanley&quot; wrote:
&gt;
&gt; &gt; Hi,
&gt; &gt; I have a spreadsheet which other people use, but I don't want them to see
&gt; &gt; the cell names I have used. Is there any way to hide the Name Box on the
&gt; &gt; screen, and stop access to the Name Manager ? I thought protecting the sheet
&gt; &gt; and workbook would do this, but it doesn't seem to.
&gt; &gt; Thanks very much.