Where are the Macro Features and Settings in Excel from Office 2007?
If you are new here, Subscribe to Full Feeds or by Email or follow us in Twitter and receive free daily updates on Office and Windows Tips, Tricks and Tweaks..
Application Macros are one of the important feature in Office application and especially for Excel. In Macros, Visual Basic for Applications (VBA) is used very widely to simplify tasks in Excel and other highly used Office applications like Word and Powerpoint.
In Excel 2003, one can access the Macro features and settings from Tools -> Macro. But in Office 2007, where are the Application Macro features and settings as there is no tab as tool in the Office Ribbon?
These settings are hidden in the tab ‘Developer‘ and this Developer tab is not shown in the Office Ribbon by default and one has to check the change the settings in Office 2007 to view the Developer tab.
So how to enable the Developer tab in Office 2007?
To enable the Developer tab, open any Office applications that uses Macros like Excel, Word or Powerpoint. Lets say we are using Excel 2007 here. Click on the Office button on the top left corner of the application. Then click on the Excel Options (You can find this near Exit Excel at the bottom).
Under the Popular tab and Top options for working with Excel, check Show Developer tab in the Ribbon. Click Ok. Now you will be able to access macros features and settings in Office 2007 through the Developer tab in the ribbon.
Read More Excel Tips and Office 2007 Tips
First time when I used Macros in 2007, I was also searching for this option.
[...] when Office 2007 came, since it was unclear to many, we had a post on where are the Macro Features and Settings in Excel 2007? Later we also saw some posts on how to create custom keyboard shortcuts in Excel using Macros. If [...]
i got the developer tab but still i have problem. visusal basic button under group code is still desable. what to do for this?
Rply soon
Regards
Ganesh Katale
I looking for the same solution…
Under the developer tab.
Make sure you change the security settings.
Change Macro Settings to “Enable all macros” and
Change ActiveX settings to “Enable all controls without restrictions and without prompting”
i got the developer tab but still i have problem. visusal basic button under group code is still desable. what to do for this?
Rply soon
very usefullink for add the developer tool in Ms office 2007 in excel
thnx a lot… it was very useful
Hi Jun and everyone who is faing the same issue, please go to control panel
Windows XP> add or remove programs> highlight Microsoft office 2007 and click on change> on the next screen select add or remove features> click on Microosft Office and select “Run all from my computer” click contiue. Check excel after the configuration is complete.
Windows Vista or Windows 7> programs> programs and features> highlight Microsoft office 2007 and click on change> on the next screen select add or remove features> click on Microosft Office and select “Run all from my computer” click contiue. Check excel after the configuration is complete.