I am using this to Change the name of My Sheet to reference a Cell for its name. It works when I change that Specific Cell but when I put data anywhere else it changes back to the Default one I select. Ultimately I want the Cell to be labeled CX1 if the K4 is Empty but Keep the Name if K4 is Populated. Any suggestions ? Thank you!
on Error resume next
if right(event.AbsoluteName, 4 ) = "$K$4" and event.String <> "" then
event.Spreadsheet.Name = event.String
event.Spreadsheet.Name = "CX 1"