Posted to microsoft.public.excel.programming

Gordon[_2_] Gordon[_2_] is offline

external usenet poster

Posts: 211

sheet tab value/nav menu

Folks...

Bit of ambitious challenge here!

I have 15 sheets. In cell A1 of each sheet the user will enter a name eg
John. I want the sheet tab for sheet 1 to change to say John. Sheet 2 tab say
Phil etc...

Also, in cell A2 I'm trying build a drop down navigation menu that uses the
names of the sheet tabs?

I'm struggling at the moment! Any help appreciated...

Gordon...

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
Custom Context menu (Right click menu) not working in sheet changeevent.	Madiya	Excel Programming	3	February 11th 08 01:24 PM
Menu sheet <- chart	Zurn[_55_]	Excel Programming	1	May 2nd 06 07:12 PM
Menu of sheet names	DesM	Excel Programming	12	November 2nd 05 11:44 AM
WHy does it only work on Menu SHeet	Nigel Bennett	Excel Programming	2	March 16th 05 04:07 AM
Is there a way to ReName a Sheet Using a Drop Down Menu?	steve	Excel Programming	0	August 22nd 03 06:23 PM

All times are GMT +1. The time now is 01:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us