| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add a footer to excel through VB code
Is it possible to add a footer to an excel doc. through VB code?
Any help will be highly appreciated. Thank U all in advance, Tej |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add a footer to excel through VB code
Hi Tej
See below: With ActiveSheet.PageSetup .LeftFooter = "&BClee Hill Electrics Confidential&B" .CenterFooter = "&D" .RightFooter = "Page &P " End With With tasks like this use the macro recorder, then delete the extra items which are not required. -- Tony Green " wrote: Is it possible to add a footer to an excel doc. through VB code? Any help will be highly appreciated. Thank U all in advance, Tej |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what code pulls in contents of a cell in an Excel header/footer? | Excel Discussion (Misc queries) | |||
| How do I code authorship into a footer? | Excel Discussion (Misc queries) | |||
| VB. NET Code to Change Excel Worksheet Header/Footer. | Excel Programming | |||
| Formatting footer in VBA code | Excel Discussion (Misc queries) | |||
| Code for Page Footer Font Size | Excel Programming | |||
Linear Mode
