Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy footer without copying page setup
Hello,
I have a workbook with many worksheets. The worksheets have different page layouts/setups. However, I need the same footer on all sheets. When I "select all sheets" and add a footer, the page setup copies throughout also. Is there a way to copy the footer without changing the page setup and without having to open every single footer to copy/paste? thanks Jen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy footer without copying page setup
Sub setfooter() For Each ws In Worksheets ws.PageSetup.LeftFooter = "SalesAidSoftware" Next End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "jen_writer" wrote in message ... Hello, I have a workbook with many worksheets. The worksheets have different page layouts/setups. However, I need the same footer on all sheets. When I "select all sheets" and add a footer, the page setup copies throughout also. Is there a way to copy the footer without changing the page setup and without having to open every single footer to copy/paste? thanks Jen |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy footer without copying page setup
Try this small macro:
Sub commonfoot() For Each s In Worksheets s.Activate ActiveSheet.PageSetup.CenterFooter = "jen" Next End Sub -- Gary''s Student - gsnu200759 "jen_writer" wrote: Hello, I have a workbook with many worksheets. The worksheets have different page layouts/setups. However, I need the same footer on all sheets. When I "select all sheets" and add a footer, the page setup copies throughout also. Is there a way to copy the footer without changing the page setup and without having to open every single footer to copy/paste? thanks Jen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
page setup landscape, but print footer in portrait mode | Excel Discussion (Misc queries) | |||
How to copy page setup | New Users to Excel | |||
Copy Page Setup across tabs | Excel Discussion (Misc queries) | |||
Page setup - footer | Excel Discussion (Misc queries) | |||
How do I copy footer setup from one tap to many tabs? | Excel Discussion (Misc queries) |