Rename linked Tab
I think you answered your own question.
"Tyro" wrote:
I need clairification. "Tab"? Excel has workbooks. Workbooks have
worksheets. Worksheets have tabs. That is to say a single worksheet has a
tab. Are you referring to worksheets as tabs?
Tyro
"Pixie78" wrote in message
...
I don't think my last post went through, sorry if it did and this is
duplicate.
I created a workbook with 5 tabs to track employee vacation. My first tab
is named 'Vacation 2007' and is all employees. The 2nd -5th tabs are the
same employees but by shift named.... A Shift, B Shift and so on. I just
copied info from 'Vacation 2007' and pasted the links in the appropriate
shift tab. Now that 2007 is over I need a new one for 2008. Well I
already
revamped my 2007 version however it will not let me rename the 'Vacation
2007' tab. I assume it's because it is linked but I just figured when I
made
it that if I changed the names the links would update to whatever I named
the
tab. Is there a way to rename my master tab without having to completely
redo my workbook??? I'd rather leave it named 2007 than make it over
again.
Thanks for any help.
|