To hide column from a table box

[#1]

Hi,

I have a table box with almost 20 columns. I do not want to display all the columns, I would need to display only few columns, but when i send to excel, i need all the 20 columns in excel.

So my view, if i can hide the columns on a table box, my display would be limited at the same time on send to excel i get all the columns.

Any help around this ?

Thanks !!

[#2]

Because macro's don't always work on the web when you are using AJAX. But if you are not using it, then no need to worry

[manojkulkarni]

which one is the correct answer ? pls put the solution here,so others can get benefited.