I have a list - Next to each item in that list, I inserted a check box (form control). I want the macro to look at each one down the list and if it is checked...go to the Sheet name, which is to the right of the check and print that sheet.
I don't want it to print at the time it is checked, but rather for the uder tp check all the ones he wants and then the print macro is run (via another control that I already have setup).
After each is run, I want the checkbox to be unchecked.
Possble?
Thanks much!!
I don't want it to print at the time it is checked, but rather for the uder tp check all the ones he wants and then the print macro is run (via another control that I already have setup).
After each is run, I want the checkbox to be unchecked.
Possble?
Thanks much!!
