![]() ![]() Here is the method I use the makes a given sheet the active sheet in the front document: Which will return the active sheet however, while one might think that e.g., tell application "Numbers" to set active sheet of front document to sheet 2Īssuming there is a sheet 2, would set e.g., sheet 2 to the active sheet, it does not set it as the active sheet. There is the active sheet property of the document, e.g., tell application "Numbers" to get active sheet of front document I'm hoping there's some really simple answer for this (I still have lots to do before I get the code to do everything I want it to, but I'm stuck here right now).Īs far as I know, Numbers does not have an explicit AppleScript command to select a given sheet. None of them seem to work, and all of them prevent the next line of code within that enclosing try statement from being executed. I know I want to select the second sheet to act on ( sheet 2 - right?) In my case I currently have 5 sheets in my spreadsheet. Most of the stuff I've found online talks about creating or deleting sheets, but I haven't found anything that provides a clear example of how to select a sheet. ![]() Set the chosenDocumentFile to "/path/to/myfile.numbers"ĭisplay alert errorNumber message errorMessage The preliminary steps are essentially: tell application "Numbers" I've been searching the Web to find a way to set the active sheet in Numbers before I attempt to make a modification there. Where I'm trying to figure out a way to do what I want using AppleScript. SUMIFS with comparisons to relative cells. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |