Access to office VBA project programming is denied

ArticleDirectory

• Office 2003 and Office XP
•  

To allow any automation client to access the VBA object model and run CodeUsers must explicitly grant access permissions to them. To enable access permissions, follow these steps.
Office 2003 and Office XP

1. Open the Office 2003 or Office XP ApplicationProgram. On the "Tools" menu, click "macro", and then click "security" to open the "macro security" dialog box.
2. On the reliable sources tab, click to select the trust access to Visual Basic Project check box to enable access permissions.
3. Click OK. If you want to perform automatic operations from the Component Object Model (COM) add-on or template, you may need to restart the application to make the code run normally.

Office 2007

1. Open the 2007 Microsoft Office system application. Click "office", and then click"ApplicationOption ".
2. Click the trust center tab, and then click trust center settings ".
3. Click the macro settings tab, click to select the "Trust access to VBA project Object Model" check box, and then click "OK ".
4. Click OK ".