Rename linked Tab

[Pixie78]

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.

 

[Tyro]

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]

I think you answered your own question.

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

 

[Gord Dibben]

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 Tools>Protection>Protect Workbook?

If so, that would prevent a name change.


Gord Dibben MS Excel MVP

 

[Pixie78]

Nevermind I fixed it.

 

[Gord Dibben]

Would you please let us know how you fixed it?

Gord