change tabname from cell ref

[Trevor3007]

good evening,

I use the following code:-

Sub MyRename()
Sheets(2).Name = Sheets(2).Range("d1") & "-Codes"
End Sub

which does work, but I want it run as soon as D1 is changed without pressing f9 or running macro.

could some cool coder please sort?

KR
Trevor3007

 

[Trevor3007]

Thanks Fluff,

yeah been there..far to compucated for me and did try but Ron did not do it for me!!


hohum…

KR
Trevor3007