| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check Box to Show/Hide Columns
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check Box to Show/Hide Columns
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check Box to Show/Hide Columns
I would like a copy if you would: -- PBANKS ------------------------------------------------------------------------ PBANKS's Profile: http://www.excelforum.com/member.php...o&userid=31370 View this thread: http://www.excelforum.com/showthread...hreadid=565663 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check Box to Show/Hide Columns
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: -- PBANKS ------------------------------------------------------------------------ PBANKS's Profile: http://www.excelforum.com/member.php...o&userid=31370 View this thread: http://www.excelforum.com/showthread...hreadid=565663 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check Box to Show/Hide Columns
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide & Show Rows based on Check Boxes | Excel Discussion (Misc queries) | |||
| how can hide and show columns using macro? | Excel Worksheet Functions | |||
| Show/Hide Columns | Excel Programming | |||
| Check boxes to show/hide Tabs | Excel Worksheet Functions | |||
| Check Box Show Hide | Excel Programming | |||
Linear Mode
