Follow avpblogs on Twitter
Home About Best Of The Blog

Recent articles

Viewing and editing macros in Excel 2007  

Office 2007 makes a complete overhaul of user interface from previous versions of Microsoft Office.

In Excel 2007,editing and viewing spreadsheet macros is now under a Developer tab group which is not enabled by default.

Here is how to enable the Developer tab which gives access to macros settings :

Open Excel 2007.

On top left,click on the Office button (yes that is a new shiny round button not present in previous Office versions)



Select Excel Options,in the Popular tab,check the Show Developer Tab in the ribbon option.





Once done,there will be a Developer tab in the main spreadsheet UI from where excel macros can be coded,viewed,tested and so on.

Cheers.

| More
Links to this post

Related Posts by Categories