default footer for charts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shanx - 01 May 2008 15:58 GMT

Hello,

By looking through the thread relating to XLStart & book.xlt and sheet.xlt,
i've been able to setup my default excel workbook to have the default footer
that i would like for all sheets.

I attempted to make one for charts, with only a chart sheet, but realized
that it would contain the data i used to make the chart sheet show up. Also
if I tried to save with only a chart sheet and no source sheet it warn me
that i'm saving a chart with no references.

I guess what i would like to know, is there a way to have the same footers
on a new chart as i have set up for in sheet.xlt.

Thanks,
David
p.s. my default workbook still only has 3 sheets and no chart, but i would
like when a new chart is made in any workbook to have this footer.

Reply to this Message

Shane Devenshire - 18 May 2008 02:35 GMT

Hi,

You might consider adding code to the

Private Sub Workbook_BeforePrint(Cancel As Boolean)

End Sub

or

Private Sub Workbook_NewSheet(ByVal Sh As Object)

End Sub

events.

Just record the steps and then paste the relevant code into the above
subroutines. Note that if the only thing you are using the sheet.xlt for is
the header and footer then the NewSheet subroutine is probably all you need.

Cheers,
Shane Devenshire
Microsoft Excel MVP

> Hello,
>
[quoted text clipped - 17 lines]
> p.s. my default workbook still only has 3 sheets and no chart, but i would
> like when a new chart is made in any workbook to have this footer.

Reply to this Message