Is there a way to ReName a Sheet Using a Drop Down Menu?
 

Otto,

Am using 97 and didn't think it worked. Thought I had tried it before. But
tried your code and IT WORKS!

This opens some interesting possibilities for me...

thanks...

--
sb
"Otto Moehrbach" wrote in message
...
Steve
I think you're wrong on that one. I have Excel 2002 and have had most
other versions in the past. I can't swear they all fire on the drop-down,
but my experience is they do. The following macro displays the MsgBox
every
time the displayed value of A1 changes.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$A$1" Then Exit Sub
MsgBox "It changed"
End Sub
Otto
"steve" wrote in message
...
Otto,

Caution. The change event doesn't fire from a Validation drop down.
A work around is to put a formula in another cell dependent on the drop
down
(as simple as = A1) and use the calculate event.

--
sb
"Otto Moehrbach" wrote in message
...
To add to what Heapy gave you. If your drop-down box is simply a Data
Validation cell in say, A1, then you can use:
ActiveSheet.Name = Range("A1").Value
You would place this line in a Worksheet_Change event macro in the
sheet
module. You would need to add code to your macro to restrict this
action
to
a change in only that one cell (A1). Post back if this is not clear.
HTH
Otto
"Joe R." wrote in message
...
I've placed a drop down menu (which doesn't print when the
sheet is printed) on a sheet. The choice selected from
the menu is placed in a cell on the spreadsheet and this
cell is printed.

What I'd like to do is rename the sheet to the value
chosen from the drop down menu. Assuming this is
possible, how is this done?