Posted to microsoft.public.excel.programming

Steve[_79_] Steve[_79_] is offline

external usenet poster

Posts: 8

Automatically Update Sheet Names

Hi All,

Does anybody know how I can automatically name the sheets of a workbook
based on the contents of a cell. For example, if I have the word January in
Cell A:1, I would like the Sheet name to be January. If I change January
to May, I would like the sheet to automatically update and rename itself to
May.

Any ideas?

Thanks,

Steve

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
Sheet tab names change automatically	MD	Excel Discussion (Misc queries)	2	June 27th 09 04:32 PM
update a sheet automatically with changing values from another she	QP1	Excel Worksheet Functions	1	July 17th 08 07:54 PM
Update Summary Sheet Automatically	MarkT	Excel Discussion (Misc queries)	7	December 18th 07 07:43 PM
how do I update a sheet automatically with the info from another?	Richard	New Users to Excel	3	April 21st 06 08:17 PM
Automatically update links when server names change	J Hotch	Excel Worksheet Functions	1	August 3rd 05 03:50 PM

All times are GMT +1. The time now is 02:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us