Kevin,
Thank you for you reply.
It works fine on any version anterior to Excel 07.
Unfortunately on Excel 07 (.XLS format) I cannot set up headers and footers
for the entire workbook (comprising of several sheets).
I selected all the sheets at once, went to Print Preview, Page Setup. When I
add a header, it only adds it on the sheet currently showing on screen but
none of the others.
I also discovered that when panes were frozen, you couldn't use the "headers
and footers" on the Insert tab. It had to unfreeze the panes and screwed the
print areas I already setup for all the sheets...
Data wise this version of Excel is a lot better, but setting up sheet is
still a nightmare.
Marion