I am needing to select rows that I don't want to be filtered out when I am
selecting filter parameters in various columns of my spreadsheet.
Is it possible to insert check boxes for each row to the left of my data so
that all that are checked will be overlooked during filtering data?
--
Thank you!

Yes. the check boxes have a property LinkedCell which will put a true or
false on the worksheet to indicate if the box is checked. You can then filer
on the true and False Values

Make the column the same for each check box and make the row the row where
the check box appears.

"Doug" wrote:

I am needing to select rows that I don't want to be filtered out when I am
selecting filter parameters in various columns of my spreadsheet.
Is it possible to insert check boxes for each row to the left of my data so
that all that are checked will be overlooked during filtering data?
--
Thank you!

How can I make the check boxes a part of the cell without placing one into
each individually? Also am I using the Activex or form controls?
--
Thank you!


"Joel" wrote:

Yes. the check boxes have a property LinkedCell which will put a true or
false on the worksheet to indicate if the box is checked. You can then filer
on the true and False Values

Make the column the same for each check box and make the row the row where
the check box appears.

"Doug" wrote:

I am needing to select rows that I don't want to be filtered out when I am
selecting filter parameters in various columns of my spreadsheet.
Is it possible to insert check boxes for each row to the left of my data so
that all that are checked will be overlooked during filtering data?
--
Thank you!

YOuca use either ActiveX or form control. The check boxes like all controls
and pictures are not part of the cell structure and sits ontop of the
worksheet. You either have to place each check box manually or write a macro
to add each check box.

"Doug" wrote:

How can I make the check boxes a part of the cell without placing one into
each individually? Also am I using the Activex or form controls?
--
Thank you!


"Joel" wrote:

Yes. the check boxes have a property LinkedCell which will put a true or
false on the worksheet to indicate if the box is checked. You can then filer
on the true and False Values

Make the column the same for each check box and make the row the row where
the check box appears.

"Doug" wrote:

I am needing to select rows that I don't want to be filtered out when I am
selecting filter parameters in various columns of my spreadsheet.
Is it possible to insert check boxes for each row to the left of my data so
that all that are checked will be overlooked during filtering data?
--
Thank you!

If not to long can I get you to write a macro for a check box in A3:A1000?

--



"Joel" wrote:

YOuca use either ActiveX or form control. The check boxes like all controls
and pictures are not part of the cell structure and sits ontop of the
worksheet. You either have to place each check box manually or write a macro
to add each check box.

"Doug" wrote:

How can I make the check boxes a part of the cell without placing one into
each individually? Also am I using the Activex or form controls?
--
Thank you!


"Joel" wrote:

Yes. the check boxes have a property LinkedCell which will put a true or
false on the worksheet to indicate if the box is checked. You can then filer
on the true and False Values

Make the column the same for each check box and make the row the row where
the check box appears.

"Doug" wrote:

I am needing to select rows that I don't want to be filtered out when I am
selecting filter parameters in various columns of my spreadsheet.
Is it possible to insert check boxes for each row to the left of my data so
that all that are checked will be overlooked during filtering data?
--
Thank you!