Hide Names
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.
|