Thanks a lot DRJ!!! It is exactly what I was trying to do. I'm relatively new to Visual Basic, Most of my macros are done with the recording option, and for some reason it did not record the check option in the boxes when I tried to do it. Probably the recording function does not "see" the checkboxes and has to be done manually. I just wasn't how to do it with programming.