Frank,

Thanks! Didn't include that since the code was looking to see if the name
needed changing and it all happens pretty fast. But it would seem to be
good form to include the disable.

--

steveB

(Remove 'NOSPAM' from email address if contacting me direct)


"Frank Kabel" wrote in message
...
Hi
you should disable event before changing the worksheet name as this
could cause also a new worksheet_claculate event

--
Regards
Frank Kabel
Frankfurt, Germany


steveB wrote:
You can use the worksheet calculate event:
Note that I had to qualify the sheet with an index number.
Also made provision if K5 = 0

''''''''''''''''''''''
Private Sub Worksheet_Calculate()
If Sheets(3).Range("K5") < 0 Then
If Sheets(3).Name < Sheets(3).Range("K5") Then
Sheets(3).Name = Range("K5")
End If
End If
End Sub
'''''''''''''''''''''''''
hth

"nuver " wrote in message
...
Hello
I want to automatically change the name of a worksheet based on the
value of cell K5 when the value of cell K5 changes. I currently have
cell K5 refering to the value of a cell in another Worksheet. Is
there a way to automatically rename a sheet based on the formula
result of a cell within that worksheet?

Thank you
Edward


---
Message posted from http://www.ExcelForum.com/