Monday, July 11, 2011

How to Convert to VBA in Excel 2007


1. Open Excel. Click the Office button and select 'Excel Options' from the bottom of the menu that opens.
2. Select the 'Popular' tab from the menu on the left. Click the box next to 'Show Developer Tab in the Ribbon.' This will allow you access the VBA editor function.
3. Click the 'Trust Center' tab and select 'Trust Center Settings.'
4. Choose 'Enable All Macros' under 'Macro Settings' and then check the box next to 'Trust Access to the VBA Project Object Model.'
5. Click 'OK.' After you exit to 'Excel Options,' click 'OK' again to go back to Excel. VBA will now be activated.

Blogger news