How to load excel vba on excel 2018
![how to load excel vba on excel 2018 how to load excel vba on excel 2018](https://www.kerneldatarecovery.com/blog/wp-content/uploads/2018/06/Excel-Cannot-Open-1-1.png)
The Developer Menu in Excel is turned off by default. I am writing this post using Excel 2013 as the tool, but the process is essentially the same for other versions too (although the user interface may be slightly different). Copy your first VBA code into your personal workbook.Set up your personal.xlsb workbook so that you have somewhere to save your VBA code.
![how to load excel vba on excel 2018 how to load excel vba on excel 2018](https://i.stack.imgur.com/g2EUv.png)
#How to load excel vba on excel 2018 how to
The purpose of this post therefore is to provide step by step instructions on how to take someone else’s VBA code (that you have permission to use) and get it working on your PC – zero VBA experience assumed. As Chip Pearson pointed out to me, you have a responsibility to ensure you have the rights to use the code. Now that I am teaching a lot of students how to use Power Pivot, I am coming across a lot of burgeoning Power Pivot users that could benefit from VBA but have exactly zero experience in how to copy and load VBA code that is made available by others for you to use. I like writing VBA for myself to solve my own problems, I like sharing what I write with others, and I like taking the VBA that others write and use it myself. VBA can automate tasks that you use often, making the process faster, easier and more accurate to execute.
![how to load excel vba on excel 2018 how to load excel vba on excel 2018](https://i.stack.imgur.com/hXRlM.png)
30 Reasons You Should Be Considering Power BI.Dimensional Modeling (Excel and Power BI).Power BI for the Business Analyst (with live Q&A).