Hide a Table using VBA

**CBV** · 03-23-2012, 03:27 PM

How can I hide a table in Excel 2007 using VBA? I'm looking for a way to turn them off and on programatically.

**shg** · 03-23-2012, 03:33 PM

Do you mean hide the rows or columns that contain the table, or something else?

**Pichingualas** · 03-23-2012, 03:36 PM

You can try with:

ActiveSheet.ListObjects("Table1").Hide

Should work if your table name is Table1, change that according to your needs otherwise.

I hoop that works.

**shg** · 03-23-2012, 03:41 PM

It might, if the ListObject object had a Hide method, but it doesn't.

**Pichingualas** · 03-23-2012, 03:45 PM

Yeah I noticed lol :P

**Pichingualas** · 03-23-2012, 03:50 PM

Maybe like so?

Range("Table1[[#Headers],[Zone Code]:[Channel]]").Select
ActiveSheet.HideSelection = True

**shg** · 03-23-2012, 03:55 PM

How well did that work when you tested it?

**Pichingualas** · 03-23-2012, 04:02 PM

Hmm... lol

Maybe this then:

Range("Table1[#All]").Select
Selection.EntireColumn.Hidden = True

**Pichingualas** · 03-23-2012, 04:02 PM

Although that wouldnt hide only the table but all the columns lol

**Pichingualas** · 03-23-2012, 04:14 PM

The way I see it, it's impossible to hide only the table. You need to hide either its rows or its columns.

@shg: is this correct?

**shg** · 03-23-2012, 04:19 PM

Yup .

**Pichingualas** · 03-23-2012, 04:21 PM

Thought so lol

Thanks :P

**CBV** · 03-23-2012, 05:35 PM

Thanks guys. So even though it's not possible to completely hide the table using VBA, is it possible to move it?

**tom1977** · 03-23-2012, 06:01 PM

try this code

ActiveSheet.ListObjects("Table1").Range.Cut Destination:=Range("a11")

check the name of your table

**shg** · 03-23-2012, 05:57 PM

Sure. Record a macro of cutting and pasting it.

Re: Hide a Table using VBA