How to Access the Developer tab in Excel 2013 – Visual Basic

Handy link outlining the procedure to open the Visual Basic Development environment inside Microsoft Excel 2013.   Alt + F11 may work for you on a PC but through virtual machines this can become problematic.   Try enabling the Developer tab for easy access through the menu bar.  Once the Developer tab is enabled, click on the Visual Basic button in the ribbon.  If a Module doesn’t exist create it as follows, then double click the module and start coding.  Possibilities are endless, but a classic use for this is stripping attachments out of your emails automatically as they arrive and onto a folder on disk.

Screen Shot 2013-07-05 at 8.54.55 AM

http://msdn.microsoft.com/en-us/library/office/ee814736(v=office.14).aspx

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

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