To build a great UI for our users, we sometimes need to emulate "buttons" in the sheet. For example, to update the data or to drill down to the next level of data.
As we don't have real buttons on Excel sheets, we should emulate them using cells with links.
To handle this, there is a very useful method on VBA's API, Workbook.FollowHyperlink
On the other hand, there is no alternative method for the Office.js. And we should use tricks like this one: https://stackoverflow.com/questions/67808095/trigger-office-js-event-when-clicking-on-an-excel-hyperlink
So please take a look at this idea; we would be very appreciative!
Kind regards, Stanislav.
No CommentsBe the first to comment
