Footer questions

  • Thread starter Thread starter Doug Boufford
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a Standard Footer 2
custom footers in excel 2003 2
Excel Unique last page footer 1
Why can't I access the footer? 10
Change Header & Footer Info w/ Worksheet Option Buttons 1
Custom Footer 2
Dates-Automatically entered in cells 7
Consecutive Numbered Pages 2

Back
Top