Hi There,

Who can help me with the following,

I have below formula to let the Sheet name be updated after filling in a
Cell (reference), this is working when i run this macro manually.

Sub Rename_Sheet()

ActiveSheet.Name = ActiveSheet.Range("M2")
End Sub

I'm now looking for a way to have the name of the sheet be updated
automatically the moment i fill in the Cell?

Is there anyone who can help me with this?

Thanks
Danny