BrightWork Tip: Turn Off ‘Enable Macros’ Warning for your Trusted Macros
If, like me, you use the BrightWork Project Sync macro to better manage your Microsoft Project to SharePoint Sync you might be interested in turning off the Microsoft Project Security Notice warning you receive every time you open the Microsoft Project file.
The warning relates to the macros in the file that are used to establish an initial connection to SharePoint and also used to manage the additional data that gets passed to SharePoint for reporting purposes during the Sync.
Although this notice is very useful, if you trust the macro is working as you would expect it can be nice to turn this warning off, even if it is only for yourself. Below are the steps (borrowed directly from “Digitally sign your macro project“).
This process involves using a certificate to sign the macro. You can get a certificate from a number of sources but for expedience here we will create one for our own private use as follows:
- Click the Windows Start button, point to All Programs, click Microsoft Office, click Microsoft Office 2010 Tools, and then click Digital Certificate for VBA Projects.
- The Create Digital Certificate dialog appears.
- In the Your certificate’s name box, type a descriptive name for the certificate.
- Click OK.
- When the SelfCert Success message appears, click OK.
Next, we will trust the macro from BrightWork.
- Open the Microsoft Project file containing the macro you want to sign.
- On the Developer tab, in the Code group, click Visual Basic.
NOTE If the Developer tab is not available: Click the File tab. The Microsoft Office Backstage view appears. Under Help, click Options. Click Customize Ribbon. In the Customize the Ribbon list, select Developer, and then click OK.
- In Visual Basic select the correct macro project i.e. BrightWorkProjectSync.
- Next, on the Tools menu select Digital Signature.
- The Digital Signature dialog appears.
- Select Choose… and select a certificate and click OK.
- Click Ok
- Save and Close the Microsoft Project file.
- Finally, Open the Microsoft Project file again. You will be prompted with the Microsoft Project Security Notice but now select Trust all documents from this publisher, after which you will not be prompted with the Microsoft Project Security Notice for this file any more.
If you subsequently want to delete the SelfCert and go back to the Microsoft Project Security Notice warning do the following:
- Open Windows Internet Explorer.
- On the Tools menu, click Internet Options, and then click the Content tab.
- Click Certificates, and then click the Personal tab.
- Select the Certificate and click Remove.
- Confirm by clicking on Yes.
- Remember to also remove the Certificate from the file by re-opening the Digital Signature dialog in Visual Basic and clicking on Remove.