Microsoft Office - VBA Unlock Automation

[petemc89]

Currently, unlocking VBA requires user intervention when opening the unlocked file for the first time:

1. Open the unlocked file and click 'Enable Content' on the warning:
2. Click 'OK' on the following pop-up:
3. Open Visual Basic from the Developer toolbar:
4. Open VBAProject Propeties under Tools:
5. Navigate to the Protection tab and enter a new password (a one character password is fine, as we will be removing it again straight away). Click 'OK'.
6. Head back in to VBAProject Properties > Protection tab, and de-select the 'Lock project for viewing' checkbox and clear any passwords in the boxes below. Click 'OK'.

This should be enhanced so that the application fulfills these steps. It should not accomplish this by mimicking user inputs (i.e. mouse, keyboard control)