Checkbox Macros
I am making a Risk Management spreadsheet for my work.
My macros are two columns of roughly 100 checkboxes, and
a print macro. Each checkbox is to update a hidden
column (with either a 1 or 0), and the print macro hides
any row with a 0 in the hidden column before printing.
This way only the relevant rows get printed.
I have tried two approaches to this, and had problems
with each. When I use the checkbox from the Forms
toolbar, I can't move and size it with the rows, so if a
user re-sizes the row, the checkboxes are no longer
aligned with the rows. When I use the checkbox from the
Control Toolbox, I have to go through each checkbox (over
200) and write a unique line of code to run. Copying and
pasting these checkboxes does not transfer the code.
Does anybody have any good ideas on how to solve my
problem? Thanks much.
|