{"id":1883,"date":"2022-08-07T10:47:41","date_gmt":"2022-08-07T07:47:41","guid":{"rendered":"https:\/\/www.addictivetips.com\/?p=367233https:\/\/www.addictivetips.com\/microsoft-office\/run-vba-code-in-office-365-apps\/"},"modified":"2022-08-07T10:47:41","modified_gmt":"2022-08-07T07:47:41","slug":"how-to-run-vba-code-in-office-365-apps","status":"publish","type":"post","link":"https:\/\/tojikon.net\/en\/1883-how-to-run-vba-code-in-office-365-apps\/","title":{"rendered":"How to run VBA code in Office 365 apps"},"content":{"rendered":"

Office 365 apps are quite capable. They\u2019ve been years in the making so you will find that they have any and all features that an average or even advanced user might need. That said, there are still enough unique use cases where the built-in feature still falls short. In many of these cases, you have to use macros or VBA code to get the job done. If you\u2019ve never run VBA code in Office 365 apps, you might be a little confused as to how it works. It\u2019s fairly simple so long as you have the code that you want to run.<\/p>\n

Run VBA code in Office 365<\/h2>\n

The process for running VBA code in Office 365 apps is similar. We\u2019re going to explain how it works in Word but it will work more or less the same in all other apps that allow you to run VBA code.<\/p>\n

Open Word and go to File>Options. On the Options window, select the \u2018Customize Ribbon\u2019 tab. You will see two columns on this tab. In the column on the right, look for the \u2018Developer\u2019 tab and make sure the box next to it is checked. If it isn\u2019t, check it.<\/p>\n

\"\"<\/span><\/p>\n

Return to Word\u2019s main interface and go to the Developer tab on the ribbon.\u00a0Here, you\u2019ll see a button called Visual Basic. Click it.<\/p>\n

\"\"<\/span><\/p>\n

Another window will open and the window is going to look as though you\u2019ve opened a new app. On this new window, go to Insert>Module. This will insert a new box within the Visual Basic window. Paste the VBA code in this window.<\/p>\n

\"\"<\/span><\/p>\n

Once you\u2019ve pasted the code, you can run it and it will run on the app that you have open e.g. if you have Word open, the code will run for the Word file and execute whatever action it is meant to execute. To run the code, click the green play button.<\/p>\n

\"\"<\/span><\/p>\n

Writing VBA code isn\u2019t exactly something everyone knows. It\u2019s not the most complicated thing to learn but if you don\u2019t know how to run VBA code in Office 365, chances are you may not know much about writing it as well. In that case, you should only run code that you know has been written by a trustworthy source. If there are errors in the code, it may not run and it will be up to you to troubleshoot it.<\/p>\n

The code may take time to run, or it may finish within seconds. It all depends on the size of the file, and the complexity of the code that is being run.<\/p>\n","protected":false},"excerpt":{"rendered":"

Office 365 apps are quite capable. They\u2019ve been years in the making so you will find that they have any and all features that an average or even advanced user might need. That said, there are still enough unique use cases where the built-in feature still falls short. In many of these cases, you have …<\/p>\n","protected":false},"author":1,"featured_media":1884,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[23],"tags":[36],"_links":{"self":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1883"}],"collection":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/comments?post=1883"}],"version-history":[{"count":0,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1883\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media\/1884"}],"wp:attachment":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media?parent=1883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/categories?post=1883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/tags?post=1883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}