I have a sreadsheet I created to do an export to Excel, but it isn't visible, so the ActiveWorksheetEditor never gets created so I can't freeze panes. Is there any way around this?
2 Answers, 1 is accepted
answered on 30 Apr 2019, 12:21 PM
Indeed ActiveWorksheet will be initialized when there are UI editor editing a specific worksheet. Instead, you can directly use the API of the WorksheetViewState for the worksheet that you get by index or by other means, for example: