Friday, October 5, 2012

How to Protect Ms Excel File Using Password


If you have Ms Excel spreadsheet/document and you want to give the protection using password, so when opening the file, you or anyone need to input the password first, then when the password is wrong, the file can't be opened.

Below is how to give password protection on Microsoft Excel 2007

• Open the Ms Excel file that will be given a password
• Click on the Office Button
• Select Prepare Menu
• Select the Encrypt Document


Then will appear the small window to enter the password


• Fill with password code that you want, and click OK
• Will be asked to repeat the password for verification, then click OK
• Save the file
• To see the result, re-open the file. there must be password request appear.



Do not forget your password, record and store in a safe place.


Good Luck....!!!

Thursday, October 4, 2012

How to Swap Mouse Button Function (right to left , left to right) Using Notepad


With computers do not always have to be serious, a lot of things you can do to reduce the stress of work or daily routine. for example with friends by swapping her/his  Mouse button function,  right button becomes left button and and vice versa left button becomes right button, so friends will feel confused. :)

Swapping  the mouse button function can be done by simply write a few commands in Notepad.

Open Notepad
type the following code :
@ echo off
rundll32 user32, SwapMouseButton



Then save the file with bat extension, for example mouse.bat




In the Save as type, select All Files
In  Encoding, select ANSI
click Save

The mouse.bat file can be copied to the flashdisk, copied on the desktop, or placed in the Windows Startup, etc, up to you, which if this bat file already executed/run, then the function of the left and right  mouse click will swap. so that the user of the computer will be confused. :)

To return to the normal function, go to  the Mouse menu  in Control Panel Windows

On the Button Configuration, give a tick  on the Switch primary and secondary buttons
Click Apply, click OK.
Another way to be back to the normal function is to restart the computer. (bat files that are not stored in the start up menu, because if it is stored in the startup after restart will be directly executed again).



Good Luck ^_^

Wednesday, October 3, 2012

How to Change Blogspot Address Using Custom Domain


Blogger allows the users to use their own domain name (Custom Domain) in his/her blog address, for example, my other blog address is firefine.blogspot.com, changed  to address to www.finetrick.com.

Replaced with your own domain name of course with different considerations, depending on needs. of course your blog will look professional.

If the traffic or  visit to the old blog address is good, with changing to new domains will decrease quite dramatically, but do not worry because when someone entering to your old blog address, then will be redirected / forwarded to the new domain address, so do not worry will lose old  visitors.

If you want to change your  blogspot address, first  you must have a domain name by buying ( actually rent) domain name you want.

To buy a domain is not difficult, many providers, you can search  on the internet. Simply, we just need a domain name, without hosting, because for hosting / storage, still using Blogger, it is very advantageous because we do not need to think about hosting and bandwidth (unlike when we use paid hosting, bandwidth depends to price)

If you already have a  domain name and want to change your blogspot address,
From Domain provider, you will get a login to get access to the Domain Registration Service for your Domain name, where there is a setting DNS (Domain Name System), which will be set to make your domain name in order to connect to Blogger
That need to be set are CNAME Records and A Records.


Create a new blog on Blogger or Open the existing blogspot which you want to change to your domain

Go to the menu Settings -> Basic
On the Menu Publishing Blog address, click + add Custom Domain




In the Advanced settings field type: your domain name, then click on Settings instruction


Once we click Settings instruction then  will leave the publishing settings page,
( leaving  the blogger page )



In Setting  instruction will be obtained : Name, IP or server name for  CNAME Records and A Records.

For CNAME records, 1st record has the same settings for each user, 
Name / Label or Host :  www 
Destinations / target, or point :  ghs.google.com


For 2nd CNAME record , its contents or setting Name / label / host and also the destination / target / points to are different for each user depending on the domain name (update blogger date 09/17/2012), intended for verification and security ( different from the previous setting, before date 09/17/2012, that do not require the 2nd CNAME record), do copy and paste, such as copy and paste into Notepad. to make easy when entry In the DNS Settings.

For A Records filled with 4 rows of records, each of which is filled with the IP destinations blogger : 216.239.32.21,  216.239.34.21,  216.239.36.21,  216.239.38.21

Keep all  information above.





Open the Domain Registration Service provided by your Domain Provider to set your DNS, you must login using username and password.
If you have trouble, you can contact  their technical support.


Create a new record for the 1st CNAME (make sure there are no other records, first remove if any) and fill  in the name/label/host :   www
then fill the value of target/destination/point to  :  ghs.google.com

Create new record for 2nd CNAME
Fill name/label/host : provided  from  Settings instruction
and target/destination/point to :  provided got  from  Settings instruction


figure sample of CNAME Records


Then create 4 (four) Records for ARecord (make sure there are no other records, first remove if any), Name : your domain
Destination IP :
216.239.32.21
216.239.34.21
216.239.36.21
216.239.38.21


 figure sample of ARecords

A Record function is to redirect if there's a blog without typing www address, will be automatically redirected to the www (as blogger does not support domain without the www, the term : naked domain)



To know if DNS already active or not, ping to your domain.

Open the command prompt.
then type : ping mydomain.com
example:
ping www.finetrick.com
and
ping finetrick.com


 Figure sample of pinging to the domain

If replying means DNS is already active, you can continue going  to Blogger custom domain settings, to set your domain in blogger, otherwise you have to wait until  DNS is active.

If DNS already active
Login to Blogger
Go to the menu Settings -> Basic
On the Publishing Blog Address  Menu, click + add Custom Domain



figure sample of Blogger Publishing Page setting
Enter Domain address in the field, then click Save.