Thanks about your quick response, but that is not my mean.
I mean, that i have a worksheet and there is no header or footer present at that. But i want there is automatic footnote every the worksheet is printed out.
On 2002-08-22 20:37, brettvba wrote:
do you mean,
Private Sub Workbook_BeforePrint(Cancel As Boolean)
MsgBox "Check Header Or Footer!"