How to move between sheets in Excel using Office Script

Soliman, Mohamed 1 Reputation point

I used to use VBA to create a button to help users move from a sheet to another sheet in the same workbook. How can I do the same using Office Script?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,435 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Michael Taylor 41,626 Reputation points

    I'm not too familiar with the Office Script API but my understanding is it is similar to the old VBA model. So given a worksheet (which you can get from the workbook) you should just need to call Activate on it. The link has an example of how you might use it.