printing related code question

  • Thread starter Thread starter anny
  • Start date Start date
A

anny

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
 
Perpahs open up a Message Box that asks the user if it printed sucessfully.
If true then change the color of the button
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing Print Preview default value 2
BeforePrint & PrintPreview Hangs 1
Access Access Report Works on One Machine but not Another 3
Print two ranges on page 2
Print preview / full screen view problem 2
Print with sevral different print area's 2
Print Preview Office 2007? 4
Closing print preview after printing 8

Back
Top