Hi Experts,
I know this is Excel Forum but i am hoping someone could help.
I am using this script to update the sheet name:
Question: How do I exclude a specific sheet (ex. Data Sheet) so that it won't be renamed in case I have to change the value in cell G1 of the Data Sheet?![]()
function onEdit(){ // Get Active Spreadsheet var sheet = SpreadsheetApp.getActiveSheet(); // Get Active Spreadsheet Name var oldName = sheet.getName(); // Get value in cell G1 of active spreadsheet and rename sheet using value in cell G1 plus "VL" var newName = sheet.getRange(1,7).getValue(); if (newName.toString().length>0 && newName !== oldName) { sheet.setName(newName + " [VL]"); } }
Thank you,
Bookmarks