Forum Discussion
Run an OfficeScript via a Button
Is it possible to use Office Scripts in a way that ANY user of a workbook can run the script? I followed the instructions (https://support.microsoft.com/en-us/office/sharing-office-scripts-in-exc...
Thank you for your feedback.
I agree, a macro-enabled file would work. In fact, that is what the original version of this file used. However, my client was specifically hoping to transition away from VBA macros since they are now blocked by default. They share this spreadsheet with a wide array of people, and talking them through how to enable the macros to run has been a point of frustration.
If any user of a workbook could operate the button to run the script, that would allow Office Scripts to fundamentally replace VBA macros for this use case.
They share this spreadsheet with a wide array of people, and talking them through how to enable the macros to run has been a point of frustration.
How about create a .net core exe with c# or java script run in web browser if VBA is not convenient to deploy?
How about create a .net core exe with c# or java script run in web browser if VBA is not convenient to deploy?