Category Archives: News

How to Unprotect an excel sheet without password

Posted on by in ,
THis document will tel you how to unprotect an excel spread sheet without having the password In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet. If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps. excel1 Press ALT + F11 or click on View Code in Developers Tabs Excel2 In the Above White Space Enter the below Code. Do not change the code just copy paste: 
Sub PasswordBreaker()
    'Breaks worksheet password protection.
    Dim i As Integer, j As Integer, k As Integer
    Dim l As Integer, m As Integer, n As Integer
    Dim i1 As Integer, i2 As Integer, i3 As...

Secure an Excel workbook with a password

Posted on by in ,
To allow only authorized users to view or modify your data, you can help secure your entire workbook file with a password. 1. On the File menu, click Save As 2. On the Tools menu, click General Options. 3. Do either or both of the following:
    • If you want users to enter a password before they can view the workbook, type a password in the Password to open box, and then click OK.
    • If you want users to enter a password before they can save changes to the workbook, type a password in the Password to modify box.
 Note   Unlike passwords you specify in the Password to open box, passwords you specify in the Password to modify box are not encrypted. These passwords are only meant to give specific users permission to modify workbook data. For optimal password security,...

Find and Change File Permissions Recursively, Linux / UNIX

Posted on by in ,
To find all files in /home/user/demo directory, enter: $ find /home/user/demo -type f -print To find all files in /home/user/demo directory with permission 777, enter: $ find /home/user/demo -type f -perm 777 -print Finally, apply new permission using the -exec option as follows: $ find /home/user/demo -type f -perm 777 -print -exec chmod 755 {} \; To select directories and subdirectories use the following syntax: $ find /home/user/demo -type d -perm 777 -print -exec chmod 755 {} \;...

Unknown table engine ‘InnoDB’

Posted on by in ,
If You are facing problem with Unknown table engine 'InnoDB' on to your mysql Database. You can do following to get rid of this problem. First look at the ib_logfile0 and ib_logfile1 in /var/lib/mysql. If they have been set to size different from the default, that probably will prevent mysqld's startup. The default for innodb_lkog_file_size is 5M. Add this in my.cnf 
[mysqld]
innodb_log_file_size = 12M
And then Proceed by doing following 
/etc/init.d/mysql stop

mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0.bak # these are your
mv /var/lib/mysql/ib_logfile1 /var/lib/mysql/ib_logfile1.bak # log files

/etc/init.d/mysql start
 ...

extract .xz format Linux

Posted on by in ,
If the file is just something.xz (without .tar) then use 
unxz something.xz
Otherwise use 
*.tar.bz2)	tar xvjf filename.tar.bz2) ;;
*.tar.gz)	tar xvzf filename.tar.gz) ;;
*.tar.xz)	tar Jxvf filename.tar.xz) ;;
*.bz2)		bunzip2 filename.bz2) ;;
*.rar)		unrar filename.rar) ;;
*.gz)		gunzip filename.gz) ;;
*.tar)		tar xvf filename.tar) ;;
*.tbz2)		tar xvjf filename.tbz2) ;;
*.tgz)		tar xvzf filename.tgz) ;;
*.zip)		unzip filename.zip) ;;
*.Z)		uncompress filename.Z) ;;
*.7z)		7z filename.7z) ;;
 ...
Page 62 of 63First PagePrev Page585960616263Next Page