Your 'Go To' for Custom Excel Solutions
excel applications

VBA Scrambler Product Support

The XLAutomation development team have put together the following Help Guidance and video's to give you assistance in getting the most out of your VBA Scrambler.

VBA Scrambler...Help Guidance

Compatibility with Windows

Compatibility Note: Before purchasing one of our Products make sure your system is compatible with our Excel Products

Operating System: Windows Only, no support for MAC OS
Microsoft Office: Office 2007 and above
Enable Macros: All our workbooks require Macro's to be enabled and trusted

Installing VBA Scrambler

After the purchase of VBA Scrambler you are provided with a "Download" link to download an installation file. You are also provided with a Serial Number to use during the product activation. Ensure that you keep a hard copy of your Serial Number for later use

Installation

After clicking on the "Download Now" link the "VBA Scrambler.xls" file will be saved to your desktop. Select an appropriate location for the workbook to stored. Once saved double click on the file to start VBA Scrambler.

Before running VBA Scrambler

Before you scramble a VBA workbook you must first ensure that the workbook you are going to scramble is unlocked. VBA scrambler needs access to the code modules of your workbook and can only do this when no password is set.

vba-scramber-no-password

For VBA scrambler to access the codes modules we must also "Trust access to the VBA project object model". To set this you must access the setting through Excel Options -> Trust Centre -> Trust Centre Settings -> Macro Settings

vba-scrambler-trust-access

Start VBA Scrambler

After opening VBA Scrambler, select the "Scramble" worksheet and then then "Start VBA Scrambler" button. The following Control Menu will be displayed. 
Simply select a file for scrambling and select the options and select "Scramble Now" to start the process.
vba-scrambler-control-menu

After Scrambling

Once the scramble routine is completed an audit report is displayed on the "Scramble" worksheet. A message indicating the new workbook that has been created with the scrambled code is shown.
 
From this point testing of the new workbook should be performed to make sure that the functionality has been maintained through the translation process.
vba-scramble-save-message