Forum Discussion

Slash77's avatar
Slash77
Copper Contributor
Apr 27, 2024

value changes sheet

Hi everyone, I'm not very expert in office script, I wrote this code but I would like the script to start when a value changes in another sheet.
for now I can only activate it via button.

Thank you

function main(workbook: ExcelScript.Workbook) {
// Refresh all data connections
workbook.refreshAllDataConnections();
// Row height
workbook.getWorksheet("Matrice").getRange("A4").getFormat().setRowHeight(200 * 3 / 4);
workbook.getWorksheet("Matrice").
getRange("F5:F1000").getEntireColumn().getFormat().setHorizontalAlignment(ExcelScript.HorizontalAlignment.left);

}

 

No RepliesBe the first to reply

Resources