No system is an island - Windows tips and tricks for all.

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.

Migrating emails from Windows Mail to Outlook 2007 is quite straightforward.

To move all messages from Windows Mail to Outlook 2007,open Outlook 2007(Start > Run > outlook).

Go to File > Import and Export.



Select Import from another program or file.



Select Outlook Express 4.x,5.x,6.x or Windows Mail.





If you have multiple email accounts configured,there will be an option to select each of them (can't select all of them at same time).



Once the migration starts,associated password with each email account will be required and the messages will be moved to Outlook 2007.After it is complete,the entire folder structure as in Windows Mail will now appear in Outlook 2007 along with all emails.

The one major disadvantage is lack of compatibility of mail rules between Windows Mail and Outlook 2007 due to which the Windows Mail rules won't work in Outlook 2007.

Happy emailing.