Print Validated Only Macro
 

Users check boxes next to worksheet name, eg "Sheet1 & Sheet2".

These checkboxes are linked to two cells, A1 & A2, respectively.

There is a button that needs to print the corresponding sheet if th
value of its linked cell = TRUE.

The button is set up now to just print both sheets.

How do I add the validation

Attachment filename: print_selected.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=59406
--
Message posted from http://www.ExcelForum.com