I have a spreadsheet which the sales rep puts in the various customer equipment counts they want to have serviced.
The equipment tab calculates the cost and sales price into selected systems and coverages.

Next to each system, there is a selection box, activeX yes, no box,
if the sales rep checks the box, the pre calculated price shows up.

Problem:
1) I use a grouping to hide the unused system rows, BUT the bottom row of check boxes didn't hide when grouping closed the rows
I have tried all property selections for moving/sizing, etc, and doesn't change the outcome on the bottom two boxes. the bottom two don't move or hide.
2) i saved the spreadsheet to a new name with the groupings closed and now the check boxes have disappeared.
3) the activeX check boxes are used to follow the eventual web site design.

Question:
1) Grouping rows with check boxes a good solution to hiding removing clutter of unused systems?
2) does saving to a new file with the groupings closed really delete the active x check boxes??
3) anyone have a better solution to a check box for selecting, true/false?


thanks. . .

sportsguy