How can I clear the list of built-in footers in Excel?
 

How can I clear the list of built-in footers in Excel?

Assuming you are talking about Print Footers:

Select...
FILE / PAGE SETUP / CUSTOM FOOTER

Then highlight the section (left, center or right) and delete the contents.

Select...
OK / OK

Programatically, you would use something like...
'/============================/
Sub FootersDelete()
With ActiveSheet.PageSetup
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
End With
End Sub
'/============================/

HTH
--
Gary Brown



"Willy Lumague" wrote:

How can I clear the list of built-in footers in Excel?

Willy

You don't.

The only thing you can change in there is the user name at
ToolsOptionsGeneral and the Author you find under FilePropertiesSummary.


Gord Dibben Excel MVP

On Thu, 5 May 2005 00:52:03 -0700, "Willy Lumague"
wrote:

How can I clear the list of built-in footers in Excel?