Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |