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
|
|||
|
|||
Copy/Rename a sheet
After I've copied an existing sheet, I then rename it, but when I go to print
it keeps the original sheets name, not the new name I gave it. How can I change this so it has the heading of the correct name. |
#2
|
|||
|
|||
Copy/Rename a sheet
Hi Darry,
You have hard coded the Sheetname in the header File, Page Setup, Headers & Footers, Custom header Or you have a macro you used to set this information, and you would have to rerun the macro or make it more automatic. http://www.mvps.org/dmcritchie/excel/pathname.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "DK" wrote in message ... After I've copied an existing sheet, I then rename it, but when I go to print it keeps the original sheets name, not the new name I gave it. How can I change this so it has the heading of the correct name. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Rookie at linking - need a tudor!!! | The Smuffer | Worksheet Functions | 8 | March 7th, 2006 05:39 PM |
How to get a row consecutive from a sheet to another | rodante | Worksheet Functions | 4 | October 30th, 2005 06:20 PM |
Does excel recognise names rather than cells? | Sue | Worksheet Functions | 9 | May 22nd, 2005 04:51 AM |
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | RonMc5 | General Discussion | 9 | February 3rd, 2005 12:51 AM |
Obtaining the sheet name within a cell for each sheet | mrhicks | Worksheet Functions | 2 | August 26th, 2004 04:06 PM |