create a dynamic hyperlink to a excel online workbook specific sheet

[promoboy]

Is it possible to create a clickable link to excel online to go to a specific sheet?
i have the good hyperlink to go to the document but not to go to the specific sheet
the working link to the document is:

=hyperlink("https://somesite.sharepoint.com/:x:/r/sites/Sharepointname/Shared%20Documents/Planning/2023/Planning_Week%2012.xlsm?&web=1", "Link")

this opens the workbook online even when it is clicked in desktop application

someone can help me?

 

[OaklandJim]

Don't know from your description if this will work for you but you could put a workbook open event into the workbook so that when user opens the file they are taken to the respective sheet. The workbook must be macro enabled (.xlsm file). This takes user to Sheet1 when the workbook is opened. Hopefully you know about events?

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Activate
End Sub

 

[promoboy]

Don't know from your description if this will work for you but you could put a workbook open event into the workbook so that when user opens the file they are taken to the respective sheet. The workbook must be macro enabled (.xlsm file). This takes user to Sheet1 when the workbook is opened. Hopefully you know about events?

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Activate
End Sub

Jim,
Thanks for your reaction.

It's not possible in vba because the workbook runs in the excel online environment and it need to be dynamic.
I have a dashboard with button for all days of the month.
Every week is a other workbook and every day is a sheet in those workbooks.
So when people press on a specific day, that workbook should open on that specific day (sheet) all in online excel without vba.
So i was thinking doing it with a hyperlink formula, only the hyperlink does work in excel dektop app but not online.
this is my formula that works in excel desktop but not online:

https://somesite.sharepoint.com/sites/mysharepoint/Shared%20Documents/FOLDER/2023/Planning_Week 8.xlsm#maandag!

this opens the workbook online but need to adjust that to the sheet:

https://somesite.sharepoint.com/:x:/r/sites/mysharepoint/Shared%20Documents/folder/2023/Planning_Week%208.xlsm?&web=1