[mso] Re: Rename a Spreadsheet tab

Hello Lisa
Thank you for the reply. I typed the formula (exactly) into cell A1, but it
doesn't work for me. I am using 2003.

I renamed the tab to be BAR then typed in the formula, I also did it the
other way round, formula first then rename tab. Am I missing something?

Thanks

John

2008/11/6 Green <1z@xxxxxxxxxxxxxx>

> Hi John,
>
> I wanted to do this a while back and rather than write VBA code I settled
> for doing it the other way around. I renamed the sheet and set up A1 to
> reflect the new name. The formula I use is...
> =TRIM(MID(CELL("filename",A1),(FIND("]",CELL("filename",A1))+1),50))
> The CELL("filename",A1) function returns a *very* complete reference to
> that
> cell.
> The FIND then finds the first occurence of ].
> The MID function then takes the string and picks out the text +1 character
> after the find to the end.
>
> HTH
> Lisa
>
> > Is there a way in which I can automattically rename a tab to
> > show what is entered in cell A1?
> > For example; If I run a hotel business that has different
> > workbooks for the Bar, Restaurant and Rooms etc. The first
> > sheet will be an amalgamation of all the workbooks,  on the
> > second worksheet I type "BAR" into cell A1. I then want this
> > to rename the tab from sheet2 to BAR.
> >
> > All help will be greatly appreciated.
> >
> > John
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the
> dropdown menu at the top.  This will allow you to unsubscribe your email
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister
> group.  This group will not allow for posting of emails, but will allow you
> to join and share problem files, templates, etc.:
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your
> email messages, read these instructions that explain why and how to fix it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
>


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: