printing related code question
 

hello

This question is related to a different one I asked yesterday. I have a
button (from form toolbar) that I use to open a report in Print Preview
mode:

With Worksheets("PrintRpts")
.PrintOut copies:=PrintNumber, preview:=PrntPrev
End With

Actually there are several such buttons opening different variations of the
report. To help me keep track of which reports have been printed, I'd like
to change the text color on the button (from ColorIndex 11 to ColorIndex 3),
but ONLY if the report is actually printed. Currently the button changes
color when the button is clicked, even if I then cancel the preview.

Any clues how to do this?
Thanks, anny

printing related code question
 

Perpahs open up a Message Box that asks the user if it printed sucessfully.
If true then change the color of the button

"anny" wrote:

hello

This question is related to a different one I asked yesterday. I have a
button (from form toolbar) that I use to open a report in Print Preview
mode:

With Worksheets("PrintRpts")
.PrintOut copies:=PrintNumber, preview:=PrntPrev
End With

Actually there are several such buttons opening different variations of the
report. To help me keep track of which reports have been printed, I'd like
to change the text color on the button (from ColorIndex 11 to ColorIndex 3),
but ONLY if the report is actually printed. Currently the button changes
color when the button is clicked, even if I then cancel the preview.

Any clues how to do this?
Thanks, anny