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.

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.

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.

Your assumption about linked cells preventing a sheet name change is incorrect.

You say "will not let me rename"

What is the error message you receive when you try to rename the Vacation 2007
sheet?

Is the workbook protected under ToolsProtectionProtect Workbook?

If so, that would prevent a name change.


Gord Dibben MS Excel MVP

On Tue, 8 Jan 2008 13:35:01 -0800, Pixie78
wrote:

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.

Nevermind I fixed it.

"Pixie78" wrote:

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.

Would you please let us know how you fixed it?

Gord

On Tue, 8 Jan 2008 15:08:03 -0800, Pixie78
wrote:

Nevermind I fixed it.

"Pixie78" wrote:

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.