Office Scripts is now generally available in Excel for the web

Microsoft is blocking macros by default in recent versions of Excel.

For users of Office Family or Personal plans, if a file is stored on OneDrive it is pretty much impossible to unlock macros without changes to the windows registry or moving files in other locations.

This is an impractical solution, especially for files shared with other users.

Although Office Scripts does not support all VBA features, extending Office Scripts to consumer licenses could be a valid way to overcome (at least partially) the VBA macro blocks

Is this feature ever coming to non-business plans?

Is there are timeline when Office Scripts will be available in any of the government tenants?

Hi. Please provide this feature for Office 365 Family versions. Those organisations which does not have use-case for whole 500-1000 employees to use Office 365 buy a few family licenses. Also, young people who want to upgrade their skills cannot do this sitting at home without entrerprise licenses. They should be able to use such features also.

petraronald I have looked everywhere for the answer but couldnt find it. 

If I have the licence to create, edit and run office script in online excel, and I create a button to run the script in excel. 
The users with basic licence (who can't not create office script), can they click on my button to run the script? 

I'm thinking to upgrade my licence to explore all the possibilities with office scripts. 

Thank you 

Robert

Any plans to make this available to consumer and replace VBAs on desktop?

MrAnalytics , RobEric365 , The question of Office Scripts vs. Office 365 consumer licenses is asked/answered upthread. Right now it seems it's "no plan". And, to the extent that Office Scripts is hopelessly entwined in corporate-IT-speak stuff like Office tenants and scripts only being able to exist on OneDrive, I say good riddance.

I was just revisiting this, after reading RobEric's post, and stumbled on this two-year-old but still seems highly relevant reddit thread: alternatives to VBA: Excel. VBA is still very much relevant, for reasons described well in that thread.

I understand, I guess, why Microsoft doesn't want to wholesale refactor VBA for the 21st century and all the environments Excel now runs in. What I can't understand is why they seem to have completely abandoned it in terms of even minor improvements and bug fixes, despite its popularity and many unique advantages for what it is and does, nor why none of the "alternatives" they've tinkered with seem to make much effort to meet the same requirements VBA uniquely satisfies, namely universal availability (at least on Windows and, kinda, sorta, on the Mac--many of my VBA tools fail on Mac because of missing references, primarily Windows Scripting Runtime to get modern things standard in newer languages like Dictionary and FileSystemObject), and integration/user friendliness/user accessibility with Excel and the Excel UI OOB. A "Hello World" example of Excel+VBA is still vastly simpler in VBA than in any of the other alternatives and can be completed by ANY Excel desktop user in a matter of minutes and without leaving Excel. (Assuming their corporate IT hasn't maimed access to VBA.) NONE of the alternatives come close. Edit to add: that five minute "Hello World" can be a UDF, code behind a control like a button, event code (Workbook, Worksheet, etc) or whatever. It can even be a macro recording. What of the VBA alternatives comes remotely close?

VBA helped make Excel ubiquitous. The requirements it satisfies aren't going away. Too bad Microsoft hates it so.

Hi RobEric365 , See Manage Office Scripts settings - Microsoft 365 admin | Microsoft Docs

for info on licensing.

Microsoft says: "Ensure users in your organization have a valid license for a Microsoft 365 or Office 365 commercial or EDU plan that includes access to Office desktop apps..."

So, perhaps, you can upgrade or change your family subscription to one of these? You can log a support call with Microsoft about this. They will be happy to help you. Just tell them you "want Office Scripts enable, please"

🙂

I am wating for Office Scripts to be available in the Office 365 Family subscription. Being retired I have no access to an enterprise version anymore. 

Hi max1981 , the process will run anymore because, as recommended by Microsoft, there should be a "Line Manager" role for each user in any given tenant. The purpose of that role is to automatically take over ownership of artefacts like Power Automate Flows, Power Apps and Power BI datasets and so on. Business processes are not the remit of Office 365 or Azure admins. Office Scripts and Flows etc are automatically deleted after (?) 90 days when a user leaves a tenant.

My general concern is with Admins who refuse to allow Office Scripts to run ever. There is no excuse for that as there is no security risks.

I think Microsoft should make it clearer to Office 365 and Azure Admins that Office Scripts is very different (i.e. is not) VBA and therefore does not have the inherent security risks that VBA had.