Friday, 8 February 2013

How to recover forgot password for Excel protected sheet

It’s quite hard when you can’t remember the protected excel sheet password that you’ve set years ago. There are two ways to resolve this.

  1. Copy all the data from the sheet and create a new sheet. This is quite simple method but this won’t work for sophisticated excel sheet with many formulas and reference.

  2. To create the macro which can retrieve the password and run it.

If you decide to use the second method, here are the steps.

First go to Developer tab, then click Macro. (For excel 2003 or below, go to Tools --> Macro --> Visual Basic Editor.)

Then you’ll see the following dialog, just type some name, I use “test”, then click on create.

Then copy paste the following code.

After that click on Play button as shown in screenshot below.

That’s it! You should be able to see your forgotten excel sheet password in the popup window.

Monday, 23 July 2012

Disable Firefox speed dial aka new tab with previews (Step-by-step instructions)

Since Firefox 13, Mozilla has introduced new feature which is commonly known as speed dial among Opera fans. Whenever new tab is started, it’ll show the nine most frequently visited sites in preview. It may be useful for some people, but many other people find it really annoying.

Unfortunately, as of version 14.0.1, Mozilla hasn’t provided any easy option to disable it.

So here are the steps by steps instructions to disable it via about:config.

  • Firstly, type about:config in address bar. You’ll receive the following warning. Just click on “I’ll be careful, I promise!”

  • Then type “browser.newtab.url” in the search box of about:config window.

  • Double-click on that Value. Then type “about:blank”. Click OK.

  • You’ll see the new value as follow:

  • Just close that tab and open new tab. You’ll no longer see that annoying speed dial anymore. Enjoy!

Tuesday, 17 July 2012

How to add multiline AutoCorrect entry using “Formatted text” in Outlook

It is quite frustrating to find out that Formatted text option in AutoCorrect dialog box is disabled (greyed out) in Outlook.

If you want to use Formatted text for Autocorrect, firstly you need to ensure that you are using Microsoft Word as your default text editor in Outlook.

After that you can follow these steps. I demonstrated here only for Outlook 2010, but the steps are quite similar for other Outlook as well.

First of all, create new message and type the text that you want as formatted text.

Then Click on File –> Option. You’ll see the following dialog box.

After you’ve clicked on Spelling and Autocorrect, you’ll get another dialog box as follow :

Click on AutoCorrect Options. You’ll see that the text you’ve selected in your new message is already in “With:” dialog box and Formatted text option has been already chosen.

Just Type your keyword in “Replace:” dialog box. (For this example, I’ve typed as *sign*). Press Add.

This is it! From now on, whenever in your new message you can just type *sign* and AutoCorrect will do the rest for you.


Source : Emailclient-Expert

Monday, 16 July 2012

How to resolve “Microsoft.PowerShell_profile.ps1 cannot be loaded because the execution of scripts is disabled on this system.”

When I tried to make the change on my Windows Powershell profile, the changes didn’t take effect. Instead I’ve got the following error :

According to Technet, the error is due to Execution policy of the computer. Microsoft set it restricted by default. Basically you are not allowed to execute any other script except those signed by Microsoft. This is to keep script-kiddie hackers at bay.

If you’re sure you don’t mind the risk, here are the steps to enable Powershell to be able to run any script.

First you need to run it as Administrator. You can do it by right-click on Powershell icon and choose Run as Administrator.

Then you can check your current policy status by typing “Get-ExecutionPolicy”. If you see it Restricted, then you can proceed to the next step.

Type “Set-Executionpolicy -ExecutionPolicy Unrestricted”

When it asks you “Do you want to change the execution policy?” Just choose Yes by typing Y or simply pressing Enter key.

This is it! Now you can Run any script you want in Windows Powershell.


Source : Technet

Thursday, 14 June 2012

How to customize Shortcuts in File Open and Save As dialog boxes

Whenever I want to open file or save in Windows XP, it is quite time wasting to navigate to the folder I frequently used.

Even though Microsoft has provided Five Shortcuts (My Recent Documents, Desktop, My Documents, My Computer and My Network Places)  in Places Bar on the left side, those shortcuts are not much useful for me.

One of my colleagues has pointed out that there is simple freeware called “Placesbar Editor”. I prefer this over PowerToys XP and registry editing method as this tool is simpler and not bloated.

All you need to do is download and install it.

Just choose, any folder you want by clicking checkbox custom. Don’t worry about losing defaults folder, you can always rollback the changes by clicking on Defaults icon.

That’s it, very simple. Enjoy your new shortcuts!

Tuesday, 29 May 2012

How to configure Chrome to use SOCK5 proxy without effecting IE setting

One of the most frustrating thing about Chrome is that it doesn’t use separate proxy setting. Its proxy settings are shared with Windows.

So whenever you want to make a change for Chrome proxy, it’ll affect all other applications that use Windows proxy setting including Internet Explorer, Safari, etc.

However, after digging around in Chromium Dev documentation and a few trials and errors, I’ve found a way to setup Chrome to use SOCK5 without having to use Windows network setting.

The thing is Chrome can accept command-line option when it starts up. You can pass some parameters to Chrome using command-line or via Shortcuts. For convenience sake, I’ll mention here only Shortcut method, but command-line junkie can feel free to type it in command prompt.

  • Right-click your Chrome Shortcut, Choose Properties

  • Then Type in --proxy-server=socks5:// (Change to correct IP and Port for your proxy)

This is it! When you click on that Shortcut to start Chrome, you’ll notice your Chrome is connecting to the internet via your proxy.

Source : Chromium Dev

Sunday, 15 January 2012

How to create Network Drive for local folders

The reason why you would want to create Network Drive for local folders is for convenience. It is easier to browse to X: or Y: drive rather than going to “C:\Documents and Settings\username\My Documents\Destination”.

At first, I tried to use Windows XP built-in Explorer command Map Network Drive under Tools Menu. But this couldn’t map local folders.

But thanks to Techrepublic, there is old DOS command still available in Windows XP (I’m not sure it may be available in Vista or Windows 7).

All you have to do is Go to command prompt.

Start Menu –> Run –> Type “cmd”
Type “subst x: C:\Documents and Settings\username\My Documents\Destination

You should change X: to any drive letter that you desire and “C:Documents and SettingsusernameMy DocumentsDestination” should be any of your target local folders.

After you’ve executed that above command, you can go to My Computers and you’ll see the brand new drive letter with your favorite folders content.

Source : TechRepublic