Prev: Main Form - copy exact data from multiple worksheets with live lin
Next: Help to create a formulae
From: fix me on 15 Mar 2010 19:28
Hello,

Maybe you guys can help me. Is there a way rename the worksheet tabs
in an Excel file that I've already created?

Example...

I've already created a fancy Excel report using SSRS. The problem
is...SSRS has no way to rename the 10 worksheet tabs to more
meaningful names.

Any ideas?

Thanks!
From: "David Biddulph" groups [at] on 15 Mar 2010 19:33
Double-click on the tab. That will let you rename the sheet.
Alternatively, right-click on the tab, and choose "Rename" from the menu.
--
David Biddulph


"fix me" <brickpack(a)gmail.com> wrote in message
news:85c00dd8-0a8f-4c32-8d12-f71c5ebcda51(a)l12g2000prg.googlegroups.com...
> Hello,
>
> Maybe you guys can help me. Is there a way rename the worksheet tabs
> in an Excel file that I've already created?
>
> Example...
>
> I've already created a fancy Excel report using SSRS. The problem
> is...SSRS has no way to rename the 10 worksheet tabs to more
> meaningful names.
>
> Any ideas?
>
> Thanks!


From: Gord Dibben on 15 Mar 2010 19:55
What would be more meaningful names?

Say you have a list of meaningful names in A1:A10 of Sheet1

Sub NameWS()
'name sheets with list in A1:A10 on first sheet
On Error Resume Next
For i = 1 To Worksheets.Count
Sheets(i).Name = Sheets(1).Cells(i, 1).Value
Next i
End Sub


Gord Dibben MS Excel MVP

On Mon, 15 Mar 2010 16:28:16 -0700 (PDT), fix me <brickpack(a)gmail.com>
wrote:

>Hello,
>
>Maybe you guys can help me. Is there a way rename the worksheet tabs
>in an Excel file that I've already created?
>
>Example...
>
>I've already created a fancy Excel report using SSRS. The problem
>is...SSRS has no way to rename the 10 worksheet tabs to more
>meaningful names.
>
>Any ideas?
>
>Thanks!

 | 
Pages: 1
Prev: Main Form - copy exact data from multiple worksheets with live lin
Next: Help to create a formulae