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

Michael Taylor 47,711 Reputation points

2022-04-22T21:03:02.66+00:00

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.
Please sign in to rate this answer.
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 47,711 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 47,711 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.
Sign in to comment