MsgBox "data not found in Sheet1"
> Cancel = True
> End If
> End Sub
>
> Paul
>
> ----------
> *From:* OSA
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, April 14, 2010 8:16:34 PM
> *Subject:* Re: $$Excel-Macros$$ VBA
_
From: OSA
To: excel-macros@googlegroups.com
Sent: Wed, April 14, 2010 8:16:34 PM
Subject: Re: $$Excel-Macros$$ VBA PRINTING AND RECORD UPDATING
Hi Paul,
Thank you always for your response. I guess worksheet before print is Ok.
Please suggest a short code. thanks.
On Wed, Apr 1
Hi Paul,
Thank you always for your response. I guess worksheet before print is Ok.
Please suggest a short code. thanks.
On Wed, Apr 14, 2010 at 7:28 PM, Paul Schreiner wrote:
> There are several "event" macros in excel.
> One is called Worksheet_beforePrint
>
> there isn't a Worksheet_afterPr
There are several "event" macros in excel.
One is called Worksheet_beforePrint
there isn't a Worksheet_afterPrint macro (sorry)
but in this case, you can cause the "P" to be placed before printing.
Also, you'd want to use a sheetchange event to clear the "P" when anything is
changed.
let me kno
