Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Columns That Contain Checkboxes
Hi,
I created an expense sheet that among other items contains the following columns: Breakfast, Lunch, Dinner, Meals. Breakfast, Lunch and Dinner cells each contain a checkbox. When the checkbox is clicked (checkbox = TRUE) the linked cell display the allotted amount for the corresponding meal. Meals adds the values of Breakfast+Lunch+Dinner. The printed expense claim only needs the Meals column. When I hide the other 3 columns (Breakfast, Lunch, Dinner), the checkbox from the Dinner column shows up in the Meals column. Is there a way to remedy this? Thanks, John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Columns That Contain Checkboxes
If you rightclick on the checkbox, you'll see a Format Control option.
Select that, then Properties and change it to "move and size with cells" (but make sure the checkbox is completely within the cell) John wrote: Hi, I created an expense sheet that among other items contains the following columns: Breakfast, Lunch, Dinner, Meals. Breakfast, Lunch and Dinner cells each contain a checkbox. When the checkbox is clicked (checkbox = TRUE) the linked cell display the allotted amount for the corresponding meal. Meals adds the values of Breakfast+Lunch+Dinner. The printed expense claim only needs the Meals column. When I hide the other 3 columns (Breakfast, Lunch, Dinner), the checkbox from the Dinner column shows up in the Meals column. Is there a way to remedy this? Thanks, John -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Columns That Contain Checkboxes
Works like a charm.
Thanks Dave. -----Original Message----- If you rightclick on the checkbox, you'll see a Format Control option. Select that, then Properties and change it to "move and size with cells" (but make sure the checkbox is completely within the cell) John wrote: Hi, I created an expense sheet that among other items contains the following columns: Breakfast, Lunch, Dinner, Meals. Breakfast, Lunch and Dinner cells each contain a checkbox. When the checkbox is clicked (checkbox = TRUE) the linked cell display the allotted amount for the corresponding meal. Meals adds the values of Breakfast+Lunch+Dinner. The printed expense claim only needs the Meals column. When I hide the other 3 columns (Breakfast, Lunch, Dinner), the checkbox from the Dinner column shows up in the Meals column. Is there a way to remedy this? Thanks, John -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
Hide Columns | Excel Worksheet Functions | |||
Hide columns | Excel Discussion (Misc queries) | |||
Dynamically add Checkboxes to worksheet columns | Excel Programming |