Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Willy Lumague
 
Posts: n/a
Default How can I clear the list of built-in footers in Excel?

How can I clear the list of built-in footers in Excel?
  #2   Report Post  
Gary Brown
 
Posts: n/a
Default

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?

  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
loop trough e-mail address list to send task lists with outlook Paul. Excel Discussion (Misc queries) 2 April 14th 05 11:48 AM
LOOP - Adddress List -to email Paul. Excel Discussion (Misc queries) 0 April 13th 05 09:54 AM
Refresh a Validation List? jhollin1138 Excel Discussion (Misc queries) 3 February 17th 05 05:48 PM
Extracting Values on one list and not another B Schwarz Excel Discussion (Misc queries) 4 January 7th 05 01:48 PM
Creating a list from an existing list. Jad Excel Worksheet Functions 1 October 29th 04 06:00 AM


All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"