Excel Automate Script (Add Password)

Rozz246 That is very simple:

function main(workbook: ExcelScript.Workbook) {
  let selectedSheet = workbook.getActiveWorksheet();
  // Unprotect sheet Combined List
  selectedSheet.getProtection().unprotect("Password");
  // Refresh all data connections
  workbook.refreshAllDataConnections();
  // Protect sheet Combined List. Passwords are not recorded. Add a password below if needed
  selectedSheet.getProtection().protect({ allowAutoFilter: false, allowDeleteColumns: false, allowDeleteRows: false,
            allowEditObjects: true, allowEditScenarios: true, allowFormatCells: false,
            allowFormatColumns: false, allowFormatRows: false, allowInsertColumns: false,
            allowInsertHyperlinks: false, allowInsertRows: false, allowPivotTables: false,
            allowSort: false, selectionMode: ExcelScript.ProtectionSelectionMode.normal }, "Password");
}