How to move between sheets in Excel using Office Script

Question

How to move between sheets in Excel using Office Script

Soliman, Mohamed 1

Hi,
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?

1 answer

Your answer

Answer 1

Michael Taylor 60,326

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.

Soliman, Mohamed 1 Reputation point

2022-04-22T21:18:40.497+00:00

Thanks for your reply. However, it doesn't move the user to the sheet.
I have 2 sheets ( Sh1 and Sh2). I want to have a button on each sheet, so when the user clicks it will go to the other sheet. I used to do that easily in VBA, is it possible to do the same using Office Script?
Michael Taylor 60,326 Reputation points

2022-04-22T21:29:37.163+00:00

Please post your script so we can see it.
Soliman, Mohamed 1 Reputation point

2022-04-22T21:40:17.883+00:00

Sub GotoSh2()
' GotoSh2 Macro
Sheets("Sheet1").Select
Range("A1").Select
End Sub

Sub GotoSh1()
' GotoSh1 Macro
Sheets("Sheet2").Select
Range("A1").Select
End Sub
Michael Taylor 60,326 Reputation points

2022-04-22T22:00:47.193+00:00
This looks like your original VBA code? Can you post your Typescript/Javascript version instead? I would expect it to look something like this:

function main ( workbook: ExcelScript.Workbook ) { let sheet = workbook.getWorksheet("Sheet2"); sheet.activate(); }

You would associate this script with the button to move to "sheet2".

Unfortunately I cannot directly test your script as my account doesn't have Power Automate enabled for it.

Share via

How to move between sheets in Excel using Office Script

1 answer

Your answer