Using Microsoft Excel 2010 VBA scripting features, Excel users can save dozens - or even hundreds - of hours per year. But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. VBA and Macros is the solution. One simple step at a time, two leading Excel VBA scripting experts teach all the. I have an Excel workbook (32-bit) with Macros that works perfectly in Excel 2010, but the Macros stop working in Excel 2016 (32-bit, Office 365, but a local install of Excel). I have tried loosening up security on the Macros (allowing all to run), and changing all security in general to as low as possible, but the issue persists. When upgrading to Office 365 / Excel 2016, I found that it was extremely slow to open, and even slower to close: Waiting 20-30 seconds to open to a blank workbook, and taking over a minute to close-down excel. My investigations showed that the problem was an Office 2010 add-in.

Prerequisites

You need to have the Microsoft Windows 7 or higher as well as Microsoft Office 2007 SP3 or higher with the latest service pack and updates installed on your computer.
Please make sure that Microsoft Office Visual Basic for Application (VBA) component is selected in your MS Office installation. To verify that you need to open Microsoft Excel and click Alt+F11 key combination. If the VBA Project is opened that means you have Visual Basic for Application (VBA) in your Excel installation.

Before protect your workbook with XCell Compiler you need to enable “Trust access to the VBA project object model” MS Excel option via the following path:
Excel Options >> Trust center >> click button “Trust Center Settings…” >> Macro Settings >> enable check box “Trust access to the VBA project object model”
You need to perform this step only once, before the first compilation.

Steps

1.Download the DoneEx XCell Compiler and install it on your computer. Detailed instruction how to download and install the product you may find in video above.

2. Open your workbook by double clicking on it in the Windows Explorer. If it did not open then do the following:
Open Excel from Windows Start Menu shortcut and load your Excel spreadsheet by using the Excel File Open menu, or just Drag-and-Drop your workbook on to the Excel window.

3. Find DoneEx menu at Excel main menu.
Click DoneEx >> XCell Compiler >> Compile

Vba Converter Pack Excel 2016

4. Fill out the compilation form with your data and preferred options, then click on the “Compile” button.

Microsoft Office 2010 Converter Pack

5. When compilation is completed, close Excel, and run the EXE file. You may find the compiled EXE file at the location that you have chosen in the “Target Path” field on the compilation form.

The workbook is secured now. You can send the compiled application to your client with peace of mind.