If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
default footer for charts
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. |
#2
|
|||
|
|||
default footer for charts
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 "Shanx" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|