Print/ Print preview setup help with chart object

[IglooBass]

Greetings,

I need some help with print / print preview. I have 2 seperate print buttons setup in my application on 1 sheet. I have a data area that is set to print / print preview. I use the following code to put a special date in the footer. On the same page I also have a chart that is setup to print / print preview. I need to set the footer again to this special date - I'm assuming the chart object needs to be referenced instead of the workbook ...

Any help would be greatly appreciated.

Code is this :

Sub Saved_Date_Footer()

Set wkbktodo = ActiveWorkbook
For Each ws In wkbktodo.Worksheets
ws.PageSetup.LeftFooter = Range("date_capture").Value
Next

End Sub


Thanx,

Ed.

 

[IglooBass]

Hi,

I've figured out an answer to this - I thought I'd post it for those searching for something like this.

ActiveSheet.PageSetup.LeftFooter = "&""Ariel""&10" & Format(Sheets("Value").Range("Date_Capture").Value, "mmmm dd, yyyy")

Thanx,

Ed.