Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |