Tuesday, May 13, 2025

Excel 2003 Protection

 Press ALT +  F11 or click on View Code in Developers Tabs


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 Integer
    Dim i4 As Integer, i5 As Integer, i6 As Integer
    On Error Resume Next
    For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
    For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
    For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
    For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
    ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
        Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
        Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
    If ActiveSheet.ProtectContents = False Then
        MsgBox "One usable password is " & Chr(i) & Chr(j) & _
            Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
            Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
         Exit Sub
    End If
    Next: Next: Next: Next: Next: Next
    Next: Next: Next: Next: Next: Next
End Sub

Now Click on the Run Button or press F5:

Sunday, January 14, 2024

Can not mount Windows 11 partition in Ubuntu Linux

Note:- It happens when you are using Windows and Linux dual booting environment.
  •  Firstly check that you have not hibernate your Windows 11. if you are hibernating your windows then your drive will not mount on Linux, because its encrypted.
  • Then check BitLocker is not enabled on your Windows System, If its enabled then your drive partition is encrypted so you have  to disable your BitLocker in your Windows System.
  • For Disable BitLocker on Windows 11
                                                            Got Start Menu Settings



                                                                System => Storage


                                                            Advanced Storage Settings


                                                                    Disk & Volume


                                                        Open Properties and disable BitLocker.


I have already disabled it.
  • Now reboot your system and check your Ubuntu Linux.


Thursday, November 29, 2018

How to Enable SSH root login on Ubuntu Server


  • Change your root user password :-
        ==> sudo passwd root

  • Open the sshd_config file :-
        ==> sudo nano /etc/ssh/sshd_config

  • Find the following line in sshd_config :-
        ==> PermitRootLogin prohibit-password
  • Change the following line :-
        ==> PermitRootLogin yes

  • Then restart the ssh service :-
        ==> sudo /etc/init.d/ssh restart

How to change Ubuntu from DHCP to Static IP Address


  • Open the /etc/network/interfaces file :-
        ==> sudo nano /etc/network/interfaces

  • You can see the following lines in interfaces file :-
        ==> auto eth0
                iface eth0 inet dhcp

  • Change the following lines :-
        ==> auto eth0
                iface eth0 inet static
                address 192.168.1.11
                netmask 255.255.255.0
                network 192.168.1.0
                broadcast 192.168.1.255
                gateway 192.168.1.1
                dns-nameservers 8.8.8.8

  • Then reboot the server.

        

Friday, April 8, 2016

Install Google Cloud Print in Ubuntu Linux

  • sudo add-apt-repository ppa:simon-cadman/niftyrepo
  • sudo apt-get update
  • sudo apt-get install cupscloudprint
  • sudo /usr/share/cloudprint-cups/setupcloudprint.py
  • After it asks for Google Credentials ( it will only do this is the first time you have used CUPS CloudPrint, or your credentials are invalid ) it will then ask if you wish to add all printers from your Google Account.
  • To make it work with Google's 2 Step Verification system, you must create a "Device Specific" password, to do this go to:Google.com>Log in with your account>Click on your user name>Security>Edit authorizing applications>Enter your account pasword>set the password.
  • If you say ‘Y’ here, it will add all printers that are currently not added to your CUPS install.
  • If you would prefer to add the printers manually, say ‘N’ here, and add a printer manually:
  • Add a new printer ( via http://127.0.0.1:631 or usual interface ) as a ‘Google Cloud Print’ network printer. Select the ‘Make’ as Google, and ‘Model’ as Cloud Print.

Monday, November 9, 2015

Atheros QCA9565 Wireless Driver Installation in Ubuntu 12.04


  • Open Terminal and run following commands
  • sudo apt-get install linux-headers-generic build-essential
  • wget http://www.orbit-lab.org/kernel/compat-wireless-3-stable/v3.6/compat-wireless-3.6.6-1-snpc.tar.bz2
  • tar xvf compat*
  • cd compat-wireless-3.6.6-1-snpc
  • sudo su
  • ./scripts/driver-select ath9k
  • make
  • make install
  • modprobe ath9k
  • exit

Monday, October 12, 2015

Local Print on SAPGUI for java (Linux – MacOSX): Sap output device configuration

I have some clients starting migrating to MacOSX for daily office use, and they need the Sapgui, and off course they want to print on their local printers. I had them installed the latest Sapgui for java (rel. 7.20 at this time) but they couldn’t print on local printers with the classic LOCL/LPT1 sap device (They still could print on sap server connected printers, host spooler access method “C”).
In order to print on local printers on Sapgui for java we have to:
  • add “G” to the Host Spooler Access Methods Sap list, using Report RSPO0075 (if you don’t find this report follow the Sap Note 821519 Instructions);
  • create a new output device in Transaction SPAD with device type POST2 and access method “G”, as shown on the following images.