JS API function to prevent user from sheet interaction
It would be extremely helpful in certain cases to prevent user to interact with the sheet/workbook while some action in the task pane is required or when some process is running (e.g. when some complex sheet changes are being performed - formatting, inserting columns, inserting data, charts....).
Thank you for your input! We’ve added this to our backlog as something we want to implement. There are many items on the backlog, so we can’t set an exact estimated time for this, but we’ll keep you posted with status updates.
Office Extensibility Team
Sami Saigaud commented
Something like ScreenUpdating function in VBA will be very useful.