Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |