If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Create a custom footer for all Excel worksheets at one time...
I want to create a custom footer, just once, that could be applied to all
worksheets in an Excel workbook. Microsoft Word lets you do this, so why not Microsoft Excel? |
#2
|
|||
|
|||
BigCat
Try the code below: Be sure to substitute the information for what you want. HTH Dennis ******************************************** Sub PageSetupAllSheets() Dim EachSheet As Worksheet For Each EachSheet In ActiveWorkbook.Worksheets With EachSheet.PageSetup ' &F = File ' &A = Tab ' &D = Date ' &T = Time ' &P = Page ' &N = Pages ' ' NOTE: the "&8" that you see below is font size ' ' Chr(10) is a carrage return ' ' .LeftFooter = "&8 &D &T" .CenterFooter = "&8Your Name" ' & Chr(10) & "&D &T" .RightFooter = "&8Page " & "&P of &N" End With Next EachSheet MsgBox "Process Completed! Press OK to Continue" End Sub "bigcat" wrote: I want to create a custom footer, just once, that could be applied to all worksheets in an Excel workbook. Microsoft Word lets you do this, so why not Microsoft Excel? |
#3
|
|||
|
|||
bc
Manually....... Select all worksheets(right-click and select sheets) before setting the footer. It will be applied to all sheets. DO NOT FORGET to ungroup the sheets when done. Use a macro to set a custom footer to all sheets.......... Sub Path_All_Sheets() Set wkbktodo = ActiveWorkbook For Each ws In wkbktodo.Worksheets ws.PageSetup.RightFooter = ActiveWorkbook.FullName & " " & Chr(13) _ & Application.UserName & " " & Date Next End Sub Gord Dibben Excel MVP On Wed, 30 Mar 2005 14:13:57 -0800, bigcat wrote: I want to create a custom footer, just once, that could be applied to all worksheets in an Excel workbook. Microsoft Word lets you do this, so why not Microsoft Excel? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do you create a boxplot on excel? | kah489 | Charts and Charting | 1 | October 9th, 2004 12:29 PM |
After installing Windows XP SP2 , how do I open old Excel 2003 fil | Mike D | General Discussion | 2 | September 2nd, 2004 10:21 PM |
In Excel create index on first sheet of selected worksheets | Ken M | Worksheet Functions | 1 | September 1st, 2004 08:07 AM |
Add-in functions when starting Excel programmatically | Steve K. | Worksheet Functions | 11 | July 2nd, 2004 06:38 PM |