Forum Discussion
Solved
How to add Parameters in Worksheet Protection? Office Scripts
How can I allow formatting of columns? I tried to insert the WorksheetProtectionOptions but I keep failing. function main(workbook: ExcelScript.Workbook) {
let sheet = workbook.getW...
Thanks for the post. I replied here - https://stackoverflow.com/questions/64393820/protect-worksheet-in-office-scripts-with-options/64395382#64395382
NikolinoDE This did not help.
Certainly not the right person to help you with Javascript. But I would like to provide you with information that might help you. If not please just ignore my post.
Thank you for your time and patience and wish you much success in your project.
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("TRAVAUX");
var debug = sheet.getName();
var protections = sheet.getProtections(SpreadsheetApp.ProtectionType.RANGE);https://stackoverflow.com/questions/60092877/sheet-getprotections-no-longer-works
Nikolino
I know I don't know anything (Socrates)