|
Custom Footers.
As I have heard different stories of wether it is possible to put the
contents of a cell into a custom footer, please can someone tell me if it is possible or not. The cell contents simply contains text. Thanking you in anticipation <<<<<< Big Rick |
Custom Footers.
You need VBA to do this. In the ThisWorkbook code module, use
code like the following: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.CenterHeader = Range("A1").Text End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Big Rick" wrote in message ... As I have heard different stories of wether it is possible to put the contents of a cell into a custom footer, please can someone tell me if it is possible or not. The cell contents simply contains text. Thanking you in anticipation <<<<<< Big Rick |
Custom Footers.
Hi, Big guy. Here's some exact instructions. Just change LeftHeader to
LeftFooter, or whatever. http://vbaexpress.com/kb/getarticle.php?kb_id=739 And you can get more information about it here. http://www.cpearson.com/excel/headfoot.htm ************ Anne Troy www.OfficeArticles.com "Big Rick" wrote in message ... As I have heard different stories of wether it is possible to put the contents of a cell into a custom footer, please can someone tell me if it is possible or not. The cell contents simply contains text. Thanking you in anticipation <<<<<< Big Rick |
Custom Footers.
And you can get more information about it here.
http://www.cpearson.com/excel/headfoot.htm I'm glad someone remembered that page. I had completely forgotten about it. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Anne Troy" wrote in message ... Hi, Big guy. Here's some exact instructions. Just change LeftHeader to LeftFooter, or whatever. http://vbaexpress.com/kb/getarticle.php?kb_id=739 And you can get more information about it here. http://www.cpearson.com/excel/headfoot.htm ************ Anne Troy www.OfficeArticles.com "Big Rick" wrote in message ... As I have heard different stories of wether it is possible to put the contents of a cell into a custom footer, please can someone tell me if it is possible or not. The cell contents simply contains text. Thanking you in anticipation <<<<<< Big Rick |
Custom Footers.
LOL. How you doing, Chip? :)
************ Anne Troy www.OfficeArticles.com "Chip Pearson" wrote in message ... And you can get more information about it here. http://www.cpearson.com/excel/headfoot.htm I'm glad someone remembered that page. I had completely forgotten about it. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Anne Troy" wrote in message ... Hi, Big guy. Here's some exact instructions. Just change LeftHeader to LeftFooter, or whatever. http://vbaexpress.com/kb/getarticle.php?kb_id=739 And you can get more information about it here. http://www.cpearson.com/excel/headfoot.htm ************ Anne Troy www.OfficeArticles.com "Big Rick" wrote in message ... As I have heard different stories of wether it is possible to put the contents of a cell into a custom footer, please can someone tell me if it is possible or not. The cell contents simply contains text. Thanking you in anticipation <<<<<< Big Rick |
Custom Footers.
Many thanks for your quick responce.
I am forever grateful. -- Big Rick "Anne Troy" wrote: LOL. How you doing, Chip? :) ************ Anne Troy www.OfficeArticles.com "Chip Pearson" wrote in message ... And you can get more information about it here. http://www.cpearson.com/excel/headfoot.htm I'm glad someone remembered that page. I had completely forgotten about it. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Anne Troy" wrote in message ... Hi, Big guy. Here's some exact instructions. Just change LeftHeader to LeftFooter, or whatever. http://vbaexpress.com/kb/getarticle.php?kb_id=739 And you can get more information about it here. http://www.cpearson.com/excel/headfoot.htm ************ Anne Troy www.OfficeArticles.com "Big Rick" wrote in message ... As I have heard different stories of wether it is possible to put the contents of a cell into a custom footer, please can someone tell me if it is possible or not. The cell contents simply contains text. Thanking you in anticipation <<<<<< Big Rick |
| All times are GMT +1. The time now is 05:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com