Thanks to both of you for the suggestions. Both actually work, but there remains one little bump. If G7 is not initially blank or "Unprinted", then the button will light up red when either of the roll options is selected. But if G7 is then changed to "Unprinted', or if the entry is deleted, the button remains red. How can we modify this such that a change in either cell creates a combined condition that will trigger the macro and determine if the button should be red or not? Most of the time, when the G7 selection is made, it won't change. I just want to make sure that when it does, I'm not making the button a required step in the process when it's no longer needed.
Getting closer....