But the good thing is that stuff is associated with the pc (or user).

It doesn't travel with the workbook, right?

Myrna Larson wrote:

Hi, Jason:

That doesn't do what the OP wants. He wants, when he clicks the arrow on the
dropdown list, to see only the items that Excel put there, not any custom
entries that he made himself. AFAIK, there's no way to do what he wants.

Myrna Larson

On Wed, 8 Jun 2005 07:24:40 -0700, "Jason Morin"
wrote:

Try a macro like this:

Sub ClearAll()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
With ws.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
End With
Next
End Sub

---
To use, press ALT+F11, go to Insert Module, paste the code in the window,
and press ALT+Q. Now go to Tools Macro Macros and run it.

HTH
Jason
Atlanta, GA


"MS" wrote:

I'm trying to clear all the historical information listed under the custom
header and footer buttons. Is there a fast easy way of doing this?

--

Dave Peterson