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

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

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

.