default footer for charts




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.

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.



Shane Devenshire


You might consider adding code to the

Private Sub Workbook_BeforePrint(Cancel As Boolean)

End Sub


Private Sub Workbook_NewSheet(ByVal Sh As Object)

End Sub


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.

Shane Devenshire
Microsoft Excel MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question