Knowledgebase
KB1017 - Trust access to VBA project
In order to protect your existing spreadsheets with XLSafe PRO, the option "Trust access to Visual Basic Project" must be enabled.
|
|
This procedure is only required to run once on the computer where the XLSafe PRO files will be created.
You do not need to follow this procedure in order to open your XLSafe PRO files on other computers. To access the XLSafe PRO files on other computers you simply need to enable macros.
|
Follow the instructions below to enable this option.
Microsoft Excel 97 - 2003
1. Close down any XLSafe files and open a new instance of Microsoft Excel.
2. Navigate to "Tools/Macro/Security..."
3. Click on the tab "Trusted Publishers".
4. Click the tick box "Trust access to Visual Basic Project" and press OK.
5. Quit Microsoft Excel and re-open the application to save the changes.
Relevant Topics
Activating XLSafe PRO on your computer
Microsoft Excel 2007-2010
1. Close down all Microsoft Excel files and quit the Microsoft Excel application. Open a new instance of Microsoft Excel.
2. Click on the Microsoft Office button and then 'Excel Options'.
3. Click on the 'Trust Center' tab and then click on the button 'Trust Center Settings'.
4. Click on the tab 'Macro Settings' and ensure that the tick box for "Trust access to the VBA project object model" is checked.
5. Press OK twice and then exit Microsoft Excel.
Relevant Topics
Activating XLSafe PRO on your computer
