Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |