{"id":5225,"date":"2020-08-31T09:02:15","date_gmt":"2020-08-31T16:02:15","guid":{"rendered":"https:\/\/officedevblogs.wpengine.com\/?p=5225"},"modified":"2022-05-31T09:11:10","modified_gmt":"2022-05-31T16:11:10","slug":"office-scripts-now-enabled-by-default-preview","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/office-scripts-now-enabled-by-default-preview\/","title":{"rendered":"Office Scripts now enabled by default &#8211; Preview"},"content":{"rendered":"<p>A few months ago, we announced that Office Scripts was available for preview in Excel on the web. Today, we are excited to announce that over the next few weeks, we will be rolling out the change to make Office Scripts enabled by default for all eligible users!<\/p>\n<p>Office Scripts will be enabled by default for all users that have a commercial or EDU license that gives access to the Microsoft 365 office desktop apps such the Office 365 E3 and E5 licenses. This change will first roll out to the targeted release audience before all other eligible users.<\/p>\n<p><strong>What is Office Scripts?<\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignleft wp-image-5227 size-full\" src=\"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/08\/Office-Scripts.gif\" alt=\" Office Scripts action recorder and code editor August 31, 2020, 7:21 AM\" width=\"620\" height=\"399\" \/><\/p>\n<p>Office Scripts is an automation platform in Excel on the web that allows users with all levels of programming experience to automate their repetitive workflows. Users can record their actions with the Action Recorder to generate a script or they can create new scripts with custom logic using the Code Editor, a full TypeScript-based editor directly within Excel on the web. Additionally, users can run Office Scripts with Power Automate, allowing users to schedule scripts, to trigger scripts based on a particular event, and to automate workflows across multiple services and products.<\/p>\n<p><strong>What governance controls are available? <\/strong><\/p>\n<p>We\u2019ve heard your feedback and understand how important it is for admins to be able to control how scripting is used in an organization. Based on this feedback, we have provided admins with the ability to control who has access to Office Scripts within an organization and who can share scripts within an organization. <a class=\"Hyperlink SCXW58329359 BCX8\" href=\"https:\/\/docs.microsoft.com\/en-us\/microsoft-365\/admin\/manage\/manage-office-scripts-settings?view=o365-worldwide\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"TextRun Underlined SCXW58329359 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW58329359 BCX8\" data-ccp-charstyle=\"Hyperlink\">These controls can be accessed in the\u00a0<\/span><\/span><span class=\"TextRun Underlined SCXW58329359 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW58329359 BCX8\" data-ccp-charstyle=\"Hyperlink\">M365<\/span><\/span><span class=\"TextRun Underlined SCXW58329359 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW58329359 BCX8\" data-ccp-charstyle=\"Hyperlink\">\u00a0admin portal\u00a0<\/span><\/span><span class=\"TextRun Underlined SCXW58329359 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW58329359 BCX8\" data-ccp-charstyle=\"Hyperlink\">under Org Settings<\/span><\/span><span class=\"TextRun Underlined SCXW58329359 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW58329359 BCX8\" data-ccp-charstyle=\"Hyperlink\">.<\/span><\/span><\/a><span class=\"TextRun SCXW58329359 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW58329359 BCX8\">\u00a0<\/span><\/span><span class=\"EOP SCXW58329359 BCX8\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p>Please note that while VBA macros had the same security clearance as Excel, Office Scripts only have access to the workbook, not the machine hosting the workbook. In addition, unlike VBA macros, Office Scripts can only be shared within an organization. No external sharing is allowed. <a href=\"https:\/\/docs.microsoft.com\/office\/dev\/scripts\/resources\/vba-differences#security\">Learn more about the differences between Office Scripts and VBA macros.<\/a><\/p>\n<h3><img decoding=\"async\" class=\"alignleft wp-image-5226\" src=\"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/08\/2-1024x592.png\" alt=\"Office Scripts admin controls in the M365 admin center. \" width=\"650\" height=\"376\" srcset=\"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/08\/2-1024x592.png 1024w, https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/08\/2-300x173.png 300w, https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/08\/2-768x444.png 768w, https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-content\/uploads\/sites\/73\/2020\/08\/2.png 1432w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/h3>\n<p><strong>Learn More <\/strong><\/p>\n<p>You can learn more about Office Scripts from these resources:<\/p>\n<ul>\n<li><a href=\"https:\/\/support.office.com\/en-us\/article\/introduction-to-office-scripts-in-excel-9fbe283d-adb8-4f13-a75b-a81c6baf163a\">Introduction of Office Scripts in Excel<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/dev\/scripts\/\">Office Scripts technical documentation<\/a><\/li>\n<li><a class=\"Hyperlink SCXW4211208 BCX8\" href=\"https:\/\/docs.microsoft.com\/microsoft-365\/admin\/manage\/manage-office-scripts-settings?view=o365-worldwide\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"TextRun Underlined SCXW4211208 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW4211208 BCX8\" data-ccp-charstyle=\"Hyperlink\">Manage Office Scripts<\/span><\/span><span class=\"TextRun Underlined SCXW4211208 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW4211208 BCX8\" data-ccp-charstyle=\"Hyperlink\">\u00a0settings in the M365 Admin Portal<\/span><\/span><\/a><span class=\"TextRun SCXW4211208 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW4211208 BCX8\">\u00a0<\/span><\/span><span class=\"EOP SCXW4211208 BCX8\" data-ccp-props=\"{&quot;134233279&quot;:true,&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><strong>Next steps<\/strong><\/p>\n<p>Please feel encouraged to reach out to us as you try out the Office Scripts feature! Your input is critical to the team\u2019s ability to offer something truly great.<\/p>\n<ul>\n<li>If you have any feedback or suggestions for the new Office Scripts feature, please let us know via <a href=\"https:\/\/excel.uservoice.com\/\">User Voice<\/a>.<\/li>\n<li>If you get stuck, or have any questions about how to accomplish something, please ask questions on <a href=\"https:\/\/stackoverflow.com\/questions\/tagged\/office-scripts\">StackOverflow<\/a> under the \u201coffice-scripts\u201d tag.<\/li>\n<li>If you run into problems with the Script Recorder or one of the APIs, please send us feedback via the <em>Help &gt; Feedback<\/em> button in Excel for the Web.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Happy Office Scripting!<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Office Scripts will be enabled by default for all users that have a commercial or EDU license that gives access to the Microsoft 365 office desktop apps such the Office 365 E3 and E5 licenses. This change will first roll out to the targeted release audience before all other eligible users.<\/p>\n","protected":false},"author":69098,"featured_media":25159,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[11],"tags":[177],"class_list":["post-5225","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-add-ins","tag-office-scripts"],"acf":[],"blog_post_summary":"<p>Office Scripts will be enabled by default for all users that have a commercial or EDU license that gives access to the Microsoft 365 office desktop apps such the Office 365 E3 and E5 licenses. This change will first roll out to the targeted release audience before all other eligible users.<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts\/5225","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/users\/69098"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/comments?post=5225"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/posts\/5225\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/media\/25159"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/media?parent=5225"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/categories?post=5225"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/microsoft365dev\/wp-json\/wp\/v2\/tags?post=5225"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}