Cell reference in Header?

[mtpaper]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Is this possible via Excel or with an Applescript?

I'd like to include the contents of a cell in my header or footer.
Thanks
Marion

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Is this possible via Excel or with an Applescript?

I'd like to include the contents of a cell in my header or footer.
Thanks
Marion

You'll need an XLM macro or applescript to do this. To do it with XLM,
insert a macro sheet and enter this code:
=page.setup("&l"&!A1)
=return()

This will lace the contents of A1 of the active sheet into the left side of
the header. Add a button on the sheet to fire the macro.