Footer questions

D

Doug Boufford

Using XL 2000

How can I
(1) reference a custom footer to a cell in the speadsheet? I would like to have
in Left Footer - "prepared on" and in the center footer a date which is entered in a
cell in the spreadsheet.

AND
(2) if you create a custom footer with font formatting in one sheet of a workbook,
how can you have it placed on the footer for every sheet in the workbook?

many thanks

Doug
 
F

Frank Kabel

Hi
1. Only possible with VBA using an event procedure Before_Print
2. Select the first sheet with this footer and group all other sheets
(hold down the cTRL keya while selecting the other tabs). goto 'File -
Pagesetup' and just click OK
 
Top