Posted to microsoft.public.excel.programming

CAM

external usenet poster

Posts: 65

Rename Worksheet tab

Hello,

I have a many different workbooks that are name differentlly by individual
states for example I have a workbook call Florida I want to have the
worksheet name by the file name How do I do that? Any tips will be
appreciated. I am using excel 2007 and I just don't know the vba code to do
that. Thank you in advance.

Cheers

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't rename worksheet	Brian Preston	Excel Discussion (Misc queries)	1	October 15th 06 03:25 AM
Using information from one worksheet, to rename inserted worksheet	Lyn	Excel Worksheet Functions	0	March 24th 06 12:54 AM
Rename Worksheet	chin_un_len[_4_]	Excel Programming	5	February 1st 06 06:56 PM
Rename the worksheet	praveen_khm	Excel Discussion (Misc queries)	1	January 17th 06 08:05 PM
Add and rename a worksheet	Microsoft Forum	Excel Programming	1	December 14th 04 11:28 AM

All times are GMT +1. The time now is 11:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us