No system is an island - Using Windows And Tech Step By Step

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.

Data Execution Prevention (DEP) monitors programs and how they run from system memory,this results in many applications getting blocked by DEP in Vista.

It can be turned off or customized as per liking,the quickest way to turn on/off DEP is through the almighty command prompt.

Launch command prompt with administrator rights and type the following :
bcdedit.exe /set {current} nx AlwaysOn

This turns on DEP for all applications,not fun at all when you can't install any program after this command is executed :)

To turn off DEP,which is usually the case especially when games that run on XP without a glitch suddenly stop working on Vista (Manhunt comes to the mind) :

bcdedit.exe /set {current} nx AlwaysOff

In both the above commands,a restart will be necessary before the changed DEP settings can come into effect.

Enjoy.