Thread: Checkbox Macros
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe Strommen Joe Strommen is offline
external usenet poster
 
Posts: 1
Default 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.