AutoUpdate
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
|