Hide Names

[Stanley]

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.

 

[Jarek Kujawa]

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

 

[Jarek Kujawa]

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

is even simpler

 

[Ms-Exl-Learner]

Just select the cells for which you have applied the formula and do right
click>>Format Cells>>Protection>>Tick 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 click>>Format Cells>>Protection>>Uncheck Both the Locked & Hidden Check
boxes and give ok.

Now Protect the worksheet with a password.

If this post helps, Click Yes!

 

[Jon Peltier]

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

 

[Stanley]

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.

 

[siddharthj]

Hi Stanley,

Did you ever figure out a way to do this?

Thanks
Sid