Same Header/Footer on multiple sheets
Posted by Keiser on January 23, 2002 8:48 AM
I´ve got a problem!
Does anyone know if it is possible to put the same header/footer on multiple sheets (datasheets and chartsheets) at the same time?
I´ve got 3 sheets with data on it and I want to put the same header on them in one action witch is done so.
Select the first sheet press/hold shift and select the last sheet. View header/footer and define them, "Presto" same header/footer on them all.
Ok here´s the problem.
When I add a chart sheet to this selection and do the for-mentioned aproach it doesn´t work!!!. I´ve try´ed recording two macro´s in witch both do the same thing, that is one put´s header/footer on a regular sheet and the other on the chart sheet. Now, looking at the code it isn´t the same, thus making this impossible, or what???
I can´t use soulutions that use templates,macros or VBA