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.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast. I'm Bill Jelen.
Boy I heard a rumor the other day, that said that hey, excel 2007 doesn't support VBA.
I want to say that that's completely false.
There is a new version of excel coming out for the macintosh and because the mac is switched over to an intel-based processor, they are getting rid of VBA on the Mac platform.
But it's still alive and well in Excel 2007.
The one place you can find a little bit about "Macros" is back here on the "View" tab, where they have "View Macros" "Record Macro", or "Use Relative Reference" But if you really want to get to the whole thing, we need to go to the office icon and then down to "Excel options" and "Show Developer tab in the Ribbon". This will bring back the "developer" tab and that's where we actually have Macro "Security" being able to "Record Macro" getting the "Visual Basic" editor and all the options for "Form Controls" and "Activex Controls".
So it's still very much alive and well if we do record a macro store in this workbook Hello World and now we have a file with a macro in it. Well, we have to save it in a special way the default "File" "Save as".
If we choose an "Excel workbook", the macros get stripped out, so you have to choose "Macro-Enabled Workbook", which is a little bit of a hassle.
You know, but so what, so that actually gets saved with xlsm and that way, when someone else receives the workbook, they're kind of tipped off that there might be macros inside.
If you get a regular xlsx, you'll know there are no macros.
So anyway if you hear someone say well, hey there are no macros in 2007.
Not true. They're alive and well, they'll be around for another 10 years at least.
The Macintosh version ofcourse, you are going to lose those in the next version.
Well hey, thanks for joining us. I'll see you next time for another netcast from MrExcel.
Boy I heard a rumor the other day, that said that hey, excel 2007 doesn't support VBA.
I want to say that that's completely false.
There is a new version of excel coming out for the macintosh and because the mac is switched over to an intel-based processor, they are getting rid of VBA on the Mac platform.
But it's still alive and well in Excel 2007.
The one place you can find a little bit about "Macros" is back here on the "View" tab, where they have "View Macros" "Record Macro", or "Use Relative Reference" But if you really want to get to the whole thing, we need to go to the office icon and then down to "Excel options" and "Show Developer tab in the Ribbon". This will bring back the "developer" tab and that's where we actually have Macro "Security" being able to "Record Macro" getting the "Visual Basic" editor and all the options for "Form Controls" and "Activex Controls".
So it's still very much alive and well if we do record a macro store in this workbook Hello World and now we have a file with a macro in it. Well, we have to save it in a special way the default "File" "Save as".
If we choose an "Excel workbook", the macros get stripped out, so you have to choose "Macro-Enabled Workbook", which is a little bit of a hassle.
You know, but so what, so that actually gets saved with xlsm and that way, when someone else receives the workbook, they're kind of tipped off that there might be macros inside.
If you get a regular xlsx, you'll know there are no macros.
So anyway if you hear someone say well, hey there are no macros in 2007.
Not true. They're alive and well, they'll be around for another 10 years at least.
The Macintosh version ofcourse, you are going to lose those in the next version.
Well hey, thanks for joining us. I'll see you next time for another netcast from MrExcel.
