Thread: Hide Names
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default 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.