Forum Discussion
Slash77
Apr 27, 2024Copper Contributor
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