Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Sheet Footer
Can I have the same header/footer on differnt sheets within an Excel
document. I have 10 sheets, and currently when I want to change the footer i need to go into each sheet. I have Excel 2003 Thansk |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Sheet Footer
You can have code that sets it at print time, so all sheets get it
Private Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet.PageSetup .LeftFooter = "my value" End With End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Amit" wrote in message ... Can I have the same header/footer on differnt sheets within an Excel document. I have 10 sheets, and currently when I want to change the footer i need to go into each sheet. I have Excel 2003 Thansk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Confusing Invisible Excel Sheet | Excel Discussion (Misc queries) | |||
Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions | |||
Link from webpage to excel sheet | Excel Discussion (Misc queries) | |||
Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel |