LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
QB QB is offline
external usenet poster
 
Posts: 57
Default Chart Print Footer :: Excel 2007

I create a chart using vba and I create it on it own worksheet
(ActiveChart.Location Whe=xlLocationAsNewSheet, Name:="UsageChart"). I
need to setup the page footer so that when it prints, the date/time appear in
the lower right-hand corner.

I have tried using the following command to set it up:

Worksheets("UsageChart").PageSetup.RightFooter = Format(Date, "yyyy-mmm-dd")

but it does not work, nothing appears. What am I doing wrong?

Thank you for your help,

QB
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel chart does not print in Office 2007 Ngalu Charts and Charting in Excel 7 September 5th 12 11:20 PM
Print filters with Pivot Chart in Excel 2007 Alan J Excel Discussion (Misc queries) 0 December 21st 09 12:40 AM
Print a chart with worksheet data in excel 2007 DAVEYB Excel Discussion (Misc queries) 1 September 2nd 08 04:50 PM
print chart on full page in Excel 2007 jsc bozeman Charts and Charting in Excel 1 January 3rd 08 05:48 PM
I cannot print an Excel 2007 chart Nigel Barton Charts and Charting in Excel 3 October 19th 06 04:47 PM


All times are GMT +1. The time now is 12:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"