How to Turn an Excel Spreadsheet Into a Standalone Application

Excel is a powerful program for creating spreadsheets, and like other elements of Microsoft Office, it allows you to embed your own Visual Basic code. One problem with this, however, is that distributing your original spreadsheets to others can allow them to see your Visual Basic code, which may be proprietary information. Compile a spreadsheet into a standalone application to distribute a spreadsheet without others being able to see or copy your proprietary programming.

Young businesswoman eating lunch at desk
credit: Siri Stafford/Digital Vision/Getty Images

Step

Download and install the XCell Compiler using the link in the Resources section.

Step

Launch Microsoft Excel and open the spreadsheet that you would like to convert to a standalone EXE file.

Step

Click the Office jewel in the upper-left corner of the window. Click "Excel Options."

Step

Click the "Trust Center" link on the left side of the window, then click the "Trust Center Settings" button.

Step

Click the "Macro Settings" link on the left side of the window, then place a check in the box labeled "Trust access to the VBA project object model." Click "OK."

Step

Click the "Add-Ins" tab at the top of the Excel window.

Step

Click the "DoneEx" menu, then click "XCell Compiler" and "Compile." If XCell Compiler is not registered yet, a window will be displayed. Click "Close."

Step

Click the "..." button next to "Target Path," and browse to the location where you would like the converted file to be saved. Click the "Compile" button.

Step

Click "OK" and close Excel. Find the converted EXE file in the location that you specified in the previous step. The program will open when double-clicked just as a standard application.