How To Access Visual Basic in Microsoft Excel 2007

Accessing Visual Basic Editor In Microsoft Office Excel 2007

1. Open Microsoft Office Excel 2007

2. Click the ‘Office Button’

3. Click on ‘Excel Options’

4. Click ‘Popular’

5. Under ‘Top options for working with Excel’ make sure there is a tick next to ‘Show Developer tab in the Ribbon’

6. Now click on ‘Trust Center’

7. Under ‘Microsoft Office Excel Trust Center’ click on ‘Trust Center Settings…’

8. Click on ‘Trusted Locations’

9. Click ‘Add new location…’ and create a folder somewhere on your computer and use this folder for macros to be saved in the future.

10. Click ‘Ok’ to get back to first page.

OR

On your Microsoft Excel 2007 page press down ‘ALT’ and ‘F11’ this option is a lot quicker though you may run into errors such that using the first option may fix some of the errors you come across.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: