View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Rename linked Tab

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.