Add office scripts to shapes in Excel Online
Assign script/Vba/macro to a shape in Excel online
Thank you for sending Microsoft feedback. Your input is valuable to us and helps improve our products.
Office Scripts doesn’t yet allow shape based triggers. It is something that is of interest to us. Could you please provide some details how how you wish to use this in Excel for web?
If you have any questions, please reply back to this email.
The Microsoft Team
I want to use an online excel spreadsheet to internally track active service requests. Since everyone in my office can use a link to access a shared spreadsheet, this would be an easy, quick way to do it. I'd want a creeate a button to add a new service request. The button would add a row and perhaps prompt for entry of values in several fields. I want to be able to put a link to other documents located on our OneDrive or elsewhere online.
Finally, I want to program a button in each new row that will delete it or move it to another tab for finished service requests.
I would support shape-based script triggers - current script execution is clunky for casual excel users; a button object attached to a script would improve a workbook's UI
James Lee commented
Give feedback at https://aka.ms/oscripts
Sudhi, Yes Please !
I really would like to be able to execute a script written in Office Scripts when pressing a button in an excel spreadsheet, On of my excel online file contain automate scripts that hide and unhide fields simulating a calendar changing the month....
See also similar UserVoice idea here : https://excel.uservoice.com/forums/274580-excel-for-the-web/suggestions/41928121-connect-office-scripts-to-buttons
Would also like this. I'm completely fed-up with VBA, especially in these days of cloud software, but untill now i'm reluctant to adopt it because of 2 reasons, this being one of them. It would really ruin my UX when i'm only able to place some buttons in the ribbon.
Sudhi I would like to be able to execute a script written in Office Scripts when pressing a button in an excel spreadsheet
I think we need to interact with a user via some events associated with shapes/buttons which are plased in a list in Excel Online. Means - to be able to press button and run some script, invoke a web form (instead of VBA userForm), read soume imputs from this web form and based on this run some other Office scripts. It is impossible now.