Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New workbook - automatically insert header
You can create the macro, save it in your personal.xls and give it a
shortcut key say, H. That way everytime you create a new workbook all you need to do is hit the keys CTRL+H and your header and footer will be created for you. HTH "kevin" wrote in message ... Hi Each time I create a new workbook I want Excel to insert a the header and footer to every sheet of the new workbook. Where would I place the code for this? I guess the code would be something to similar to below With ActiveSheet.PageSetup .CenterHeader = "&A" .CenterFooter = "Printed &D &T" End With but not sure where to put it - presume in my personal workbook somewhere, but what sheet, what function etc# thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically insert time in excel but not automatically updated | Excel Worksheet Functions | |||
how to type in 1 workbook & automatically insert in another book? | Excel Worksheet Functions | |||
How do I copy a header to insert on multilpe sheets in a workbook | Excel Discussion (Misc queries) | |||
Can XLS automatically insert file properties fields into a header | Excel Worksheet Functions | |||
insert the same header in every sheet in a excel workbook | Excel Discussion (Misc queries) |