Check Box to Show/Hide Columns

[rudy]

I am just wodering if this is possible and and if anyone has done such a thing any guidance would be appreciated......

I have created a report for a user group that is not very Excel literate. The report has many columns and users need to select columns based on what they want to see. I have set up some pre-defined views but also need a simple ad-hoc component. Has any one set up a form that lists all the columns (i.e. sales units) and provides a check box that shows/hides the column based on the selection?

Thanks!

[Die_Another_Day]

Yes, would you like me to email it to you? I have it set up as an addin
so it will run in the back ground.

Die_Another_Day

rudy wrote:
> I am just wodering if this is possible and and if anyone has done such a
> thing any guidance would be appreciated......
>
> I have created a report for a user group that is not very Excel
> literate. The report has many columns and users need to select columns
> based on what they want to see. I have set up some pre-defined views
> but also need a simple ad-hoc component. Has any one set up a form
> that lists all the columns (i.e. sales units) and provides a check box
> that shows/hides the column based on the selection?
>
> Thanks!
>
>
> --
> rudy
> ------------------------------------------------------------------------
> rudy's Profile: http://www.excelforum.com/member.php...o&userid=33911
> View this thread: http://www.excelforum.com/showthread...hreadid=565663

[PBANKS]

I would like a copy if you would: [email protected]

[Die_Another_Day]

Ok, when I get home I will strip sensitive info and send it to you.

Die_Another_Day
PBANKS wrote:
> I would like a copy if you would: [email protected]
>
>
> --
> PBANKS
> ------------------------------------------------------------------------
> PBANKS's Profile: http://www.excelforum.com/member.php...o&userid=31370
> View this thread: http://www.excelforum.com/showthread...hreadid=565663

[rudy]

Please e-mail me the code at at [email protected].

Thanks!