I put this in the general Excel section, but I think it should probably go
here instead.

I am updating a very old spreadsheet that I've put 55 check boxes on with the
intent that when they are checked and a command button clicked only the pages
selected will print. These pages are already set up on the next sheet (it
used to be 55 separate sheets, but I've combined these into one), and the
page breaks have been set so each will print correctly. I've also put a check
box that I've labeled "select all" and print command button so we only print
what's needed.

Silly me, I thought I could figure this out, but the only thing I can come up
with that works is to write 55 separate macros, changing the check boxes to
command buttons, and another macro that simply clicked each button. This
seems to be very inefficient, and I was hoping someone could help me with
this. I would very much appreciate it.

--
Message posted via http://www.officekb.com