Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Don - Please help on another subject - headers
On this same directory workbook. I have a header that I want on all pages.
I made changes to the ALL ws and then I recorded a macro that would take the text from ALL ws and copy to LAST_TITLE ws. It worked when I was recording the macro, but when I run the macro - all I get is the screen jumping and nothing changes. I need to do the same on the ALL footer. I am trying to make this 'task' of updating the directory easy for the actual user who will need to update. And I thought that my creating macros would be so nice. So far the 2 macros I created aren't working - it must be me. Sub Header() ' ' Header Macro ' ' Sheets("ALL").Select With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = _ "&""Times New Roman,Bold Italic""&14Central Lakes College&""Arial,Bold""&10" & Chr(10) & "Brainerd/Staples Campus Telephone Directory €“ Klick 2008" .RightHeader = "" .LeftFooter = "&7Update 12/15/08" .CenterFooter = _ "&8 E-Mail address is: 1st initial of 1st name, last " & Chr(10) & "Names in BOLD are members of the Presidents Cabinet" & Chr(10) & "PLEASE NOTE Extensions that are 83-- can only be dialed internally" .RightFooter = "&7Page &P of &N" .LeftMargin = Application.InchesToPoints(0.41) .RightMargin = Application.InchesToPoints(0.25) .TopMargin = Application.InchesToPoints(0.75) .BottomMargin = Application.InchesToPoints(0.83) .HeaderMargin = Application.InchesToPoints(0.3) .FooterMargin = Application.InchesToPoints(0.3) .Zoom = 82 .PrintErrors = xlPrintErrorsDisplayed .OddAndEvenPagesHeaderFooter = False .DifferentFirstPageHeaderFooter = False .ScaleWithDocHeaderFooter = True .AlignMarginsHeaderFooter = False .EvenPage.LeftHeader.Text = "" .EvenPage.CenterHeader.Text = "" .EvenPage.RightHeader.Text = "" .EvenPage.LeftFooter.Text = "" .EvenPage.CenterFooter.Text = "" .EvenPage.RightFooter.Text = "" .FirstPage.LeftHeader.Text = "" .FirstPage.CenterHeader.Text = "" .FirstPage.RightHeader.Text = "" .FirstPage.LeftFooter.Text = "" .FirstPage.CenterFooter.Text = "" .FirstPage.RightFooter.Text = "" End With Sheets("LAST_TITLE").Select End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup using column headers and row headers | Excel Discussion (Misc queries) | |||
Two Headers, one subject column and various columns with data | Charts and Charting in Excel | |||
Hide Column Headers but not row (Headers) | Excel Programming | |||
No Subject | Charts and Charting in Excel | |||
No Subject | Excel Worksheet Functions |