Header/Footers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mikal77 - 15 Jun 2007 21:27 GMT

I create a Budget every year. I use the previous year's Workbook and 'Save
As' the new Workbook name. I can't seem to get rid of what appears in the
Header/Footer. I've tried many different scenarios including: 1) deleting
the info, then do an immediate 'Save.' 2) saving as a different file, etc.
Can anyone help me permanantly clear the Header/Footer? I've been using the
same Workbook for about 5 years.

Reply to this Message

Mike G - 15 Jun 2007 23:06 GMT

print preview - setup-headers or footers

>I create a Budget every year. I use the previous year's Workbook and 'Save
> As' the new Workbook name. I can't seem to get rid of what appears in the
[quoted text clipped - 3 lines]
> the
> same Workbook for about 5 years.

Reply to this Message

ShaneDevenshire - 16 Jun 2007 06:51 GMT

Hi,

It sounds like there is a VBA Before_Print macro in your workbook.
Press Alt+F11, on the top left side double click ThisWorkbook and if you
find code in the widown on the right which looks like:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
...
End Sub

Delete it.

Signature

Cheers,
Shane Devenshire

> I create a Budget every year. I use the previous year's Workbook and 'Save
> As' the new Workbook name. I can't seem to get rid of what appears in the
> Header/Footer. I've tried many different scenarios including: 1) deleting
> the info, then do an immediate 'Save.' 2) saving as a different file, etc.
> Can anyone help me permanantly clear the Header/Footer? I've been using the
> same Workbook for about 5 years.

Reply to this Message