Tips

Today I came across this site http://www.mibbit.com/ for login into IRC channels from your browser. It is great for people who don't have administrative rights on their Workstation or offices where IRC ports are blocked.

Just open the link http://www.mibbit.com/ in your browser, select the channel and you are in.

Try it.

Procedure to password protect your grub menu is simple. Steps are mentioned below.

1. Use the command grub-md5-crypt to generate an encrypted password in MD5 (Message Digest Algorithm 5) format.

2. Open your /boot/grub/grub.conf file and copy the encrypted password.

Enter the password --md5 ENCRYPTED-PASSWORD line just before the title line.

3. Restart your computer and to modify the GRUB menu first enter p and then enter the password that you encrypted.

4. Now your GRUB is MD5 password protected.

If you are an Entrepreneur and wish to start a business then you might be benefited from these links below.

http://blog.proto.in/2008/05/28/the-startup-kit-part-i/

My friend Vinod gave me a problem to change the background color of entire row to Red and also to change the font to bold. It seems to be an easy task but there are two constraints.
1. He want to do this only for those lines which has font color of red.
2. There are 2500 entries in the excel.

Now if you have plenty of time then you can do this task in some hundred years :) but I am a Lazy guy so I wrote this little Macro code.

Private Sub Workbook_Open()
For Each cell In Worksheets("sheet1").Range(Worksheets("sheet1").Range("A1"), _
Worksheets("sheet1").Range("A1").End(xlDown))
        If cell.Font.Color = RGB(255, 0, 0) Then
            cell.Font.Color = RGB(0, 0, 0)
          cell.EntireRow.Font.Bold = True
          cell.EntireRow.Interior.Color = RGB(255, 0, 0)
        End If
       
    Next cell
End Sub

You can write this code either in the Open Event of the Workbook or write a Module for it.

For Each cell In Worksheets("sheet1").Range(Worksheets("sheet1").Range("A1"), Worksheets("sheet1").Range("A1").End(xlDown))

This code simply defines the range starting from cell A1 till the bottom most cell which has any data.

End(xlDown))
This is similar to pressing Ctrl + Down Arrow

cell.Font.Color = RGB(0, 0, 0)
This code changes the font color of the cell content

cell.EntireRow.Font.Bold = True
This code changes the font to Bold

cell.EntireRow.Interior.Color = RGB(255, 0, 0)
This code fills the cell with Red color