checkboxes to run multiple ranges of macros

Hello all. I have a massive spreadsheet with 100 columns of checkboxes (not my idea; but I'm stuck with it). Each checkbox is controlled individually; PLUS I want to have a "master" checkbox at the top of each column that will check each chechbox in its column, and control the value and formatting of the adjacent cell. I have created the below code, which does what I want. The problem is with this approach I will have to manually name 2 ranges for each of the 100 columns and modify the sub checkbox code to include the correct names for all one hundred columns of checkboxes.

I am hoping to have a macro which will point to ranges (row 2 to 313 of the column where the checkbox is located) and then control those ranges depending on the value of the checkbox. Thoughts?

Please Login or Register  to view this content.

perhaps

Please Login or Register  to view this content.

Thank you! Minor modifications to specify both ranges and the exact cell values & formatting I wanted gave me the below and does exactly what I want. Can you recommend a good book on vba programming for excel? I'd like to take a more systematic approach to learning this stuff.

Please Login or Register  to view this content.

excel books:
JWalk: http://www.amazon.com/Excel-Power-Pr...d_bxgy_b_img_y
BillJ: http://www.amazon.com/VBA-Macros-Mic...ref=pd_sim_b_6
Green/Bovey/Bullen/Alexander (now there's a team!): http://www.amazon.com/Excel-2007-Pro...ref=pd_sim_b_8
the book: http://www.amazon.com/Professional-E...dp_ob_title_bk

vba book:
http://www.amazon.com/VBA-Developers...ef=pd_sim_b_87