Is there a vba code to make a sheet name equal a cell value without it being a Private Sub Workbook Change? The reason it can't be private, is because I am taking a summary sheet of a configured part number and copying the sheet within the same workbook. So making it private would cause the...