Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,318 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi everyone!!
I created my first script, very easy, I ask if it is possible to activate the script when changing a value in a table in the folder.
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); }