Look Who it Was Random video

Excel - Excel VBA Support: Debunking the Rumor and Accessing Developer Tab - Episode 687

3,934 views · Published 19 February 2009 · 2:23 · Indexed 19 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Excel VBA Support: Debunking the Rumor and Accessing Developer Tab.

Welcome back to another MrExcel netcast! I'm Bill Jelen and today we're going to debunk a rumor that's been going around about Excel 2007 not supporting VBA. Let me tell you, that is completely false. VBA is still very much alive and well in Excel 2007. The only platform that will no longer support VBA is the Macintosh, due to the switch to an Intel-based processor. But for all you PC users, don't worry, VBA is here to stay.

Now, you may be wondering where to find the VBA options in Excel 2007. Well, they can be found under the "View" tab, where you can access "View Macros", "Record Macro", and "Use Relative Reference". But if you want to fully access all the VBA features, you'll need to go to the "Office" icon and select "Excel Options". From there, go to "Show Developer tab in the Ribbon" and voila, the "Developer" tab will appear with all the options for "Macro Security", "Record Macro", and more.

So, let's say you want to record a macro and save it in your workbook. You'll need to save the file as a "Macro-Enabled Workbook" with the extension .xlsm. This may seem like a hassle, but it's worth it to keep your macros intact. Plus, if you receive a regular .xlsx file, you'll know that there are no macros included. So, don't believe anyone who says that Excel 2007 doesn't support VBA. It's still going strong and will continue to do so for at least another 10 years.

Unfortunately, for Mac users, VBA will no longer be available in the next version. But for all you PC users, keep on using VBA to enhance your Excel experience. Thanks for tuning in to this netcast and I'll see you next time for more Excel tips and tricks from MrExcel. Don't forget to like and subscribe for more helpful content!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Microsoft hides some of the VBA controls in Excel 2007. Episode 687 will show you how to access the Developer tab in the Excel 2007 ribbon.

Table of Contents:
(00:00) Rumor about Excel 2007 not supporting VBA 
(00:38) Accessing Macros through the "View" tab or Developer Tab
(00:57) Recording a macro and saving it in a workbook 
(01:35) Saving a macro-enabled workbook as xlsm 
(02:07) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
ActiveX Controls in Excel 2007
Excel 2007 developer tab
Excel 2007 VBA support
Excel options in 2007
Form Controls in Excel 2007
Future of macros in Excel 2007
Macintosh version of Excel and VBA support
Macro-enabled Workbook in Excel 2007
Macros in Excel 2007
Recording macros in Excel 2007
Saving macros in Excel 2007
Visual Basic editor in Excel 2007

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152222/

More from this channel