Nov 02 2017 03:56 PM - edited Nov 02 2017 03:58 PM
@swelch,
I just finished writting and posting some code for your similar question regarding 3 days a week sheet tabs.
The answer to your above question is to use a WorkSheet Event-Macro.
Any change to cell A1 will be reflected in the Sheets Name.
*** Remeber that Sheets Names are limited and do not aloow special characters etc'
-------------------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next ActiveSheet.Name = [A1] End Sub
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” Excel MVP – Excel (2009-2018)
ISRAEL