This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
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.
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?
Please post your script so we can see it.
Sub GotoSh2()
' GotoSh2 Macro
Sheets("Sheet1").Select
Range("A1").Select
End Sub
Sub GotoSh1()
' GotoSh1 Macro
Sheets("Sheet2").Select
Range("A1").Select
End Sub
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.