Hiding an Excel 2007 Table Name from the Name Box

Is it possible to hide an Excel 2007 Table Name from appearing in the Name Box.

(I want to prevent users navigating to my table by selecting it there)

I tried ideas like:

ListOjects("Table1").Name.Visible = False

But had no success and I can't seem to find any help anywhere about it.

Re: Hiding an Excel 2007 Table Name from the Name Box

Quote from cytop;676390

A ListObject does not have a VISIBLE property...

I noticed that. I was hoping to find a way to make it not seen though.

I can hide named ranges easily enough but I'd rather use a table for my current project.

Any ideas please?

Re: Hiding an Excel 2007 Table Name from the Name Box

I'm afraid that doesn't work. I tried a few variations of looping though ListObjects and hiding, setting visible to false, etc but nothing seems to work that I am aware of.

I just need that one line of code that says:

Table 1 name hide it from the name box or go to dialog box!

I appreciate the reply though.

Quote from royUK;676503

You can hide the name from the nameBox

Code

Option Explicit


Sub Hidename()
 Dim objName As Excel.Name
   
        For Each objName In Application.ActiveWorkbook.Names
        If objName = "Table1" Then objName.Visible = False
        Next objName
   
End Sub

Display More

If you don't want users to use the Table then put it on a hidden sheet

Re: Hiding an Excel 2007 Table Name from the Name Box

I've tried that in Office 2007 and 2010 and it works in neither.

Re: Hiding an Excel 2007 Table Name from the Name Box

I'll go with the hidden sheet idea. It's simple and it works.

Thanks for the ideas.

Quote from royUK;676857

Where are you seeeing the name of the table? It does not appear in the Name Box.

Hiding the name anywhere will not stop people navigating to it. As i said in my first post if you don't want them to do that then put it on a hiddene sheet.

Re: Hiding an Excel 2007 Table Name from the Name Box

Quote from pulsar777;767902

Hi, anyway, is there a way to hide the table names from a name box and name manager? Excel.Name object seems to work only for defined names.

I went with RoyUK's idea to:

Quote

If you don't want users to use the Table then put it on a hidden sheet