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:


    Code
    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


    You can hide the name from the nameBox



    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'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



    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


    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


    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


    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.

  • 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


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


    Hi corkant, indeed, I have those tables on hidden sheet. The names of my tables are explanatory (because of UserForms and etc), so user can imagine what is going on.
    The best would be if s/he couldn't.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!