Thursday, 22 June 2017

How to sort excel sheets within a workbook

Microsoft Excel is one of the most used spreadsheet application and has lots of features that makes data processing easier. In excel, we can use macros too and in this tutorial, I'll write about sorting excel sheets within a workbook. Follow the steps given below:
1. Open Excel and create some sheets in the workbook. Rename them and arrange them randomly (I'm assuming an example sheet to start with). I've named the sheets as navy call list.
create sheets

2. Now right click on any sheets and click "View Code" as shown in the screenshot below.

view code

3. Now "Microsoft Visual Basic for Applications" window will be opened. Click on "Insert" and click on "Module".

insert module

4. A new module will be created and a blank editor will appear. Copy and paste the following code in the editor:

Sub Sort_Active_Book()
Dim i As Integer
Dim j As Integer
Dim iAnswer As VbMsgBoxResult
'
' Prompt the user as which direction they wish to
' sort the worksheets.
'
   iAnswer = MsgBox("Sort Sheets in Ascending Order?" & Chr(10) _
     & "Clicking No will sort in Descending Order", _
     vbYesNoCancel + vbQuestion + vbDefaultButton1, "Sort Worksheets")
   For i = 1 To Sheets.Count
      For j = 1 To Sheets.Count - 1
'
' If the answer is Yes, then sort in ascending order.
'
         If iAnswer = vbYes Then
            If UCase$(Sheets(j).Name) > UCase$(Sheets(j + 1).Name) Then
               Sheets(j).Move After:=Sheets(j + 1)
            End If
'
' If the answer is No, then sort in descending order.
'
         ElseIf iAnswer = vbNo Then
            If UCase$(Sheets(j).Name) < UCase$(Sheets(j + 1).Name) Then
               Sheets(j).Move After:=Sheets(j + 1)
            End If
         End If
      Next j
   Next i
End Sub

code

4. Now click on "File" and "Close and return to Microsoft excel".

exit from the code editor

5. Now in Excel, click on "View > Macros > View Macros". It will open the saved macros.

view macros

6. In the Macro window, you should see "Sort_Active_Book" macro. Click on it and click "Run". It will open a prompt, click on Yes if you want to sort the sheet in ascending order, click NO if you want to sort the sheet in descending order.

run macro
prompt

7. That's it, you can see that the sheets in your workbook are sorted.

sorted sheets

Keep visiting for more tips and tricks.
Share:

Monday, 15 May 2017

What is a Ransomware and how to prevent it

Ransomware is a kind of malicious software which encrypts the files of infected PC upon execution and it's designed to block the access of files in a computer until a sum of money is paid to the hacker. Once the money is paid, the hacker sends a decryption key to the victim which can be used to decrypt the files and get the access back. Most of the times, even if you pay the amount, the victim doesn't get any decryption key and it is almost impossible to track the attacker because they accept the money through bitcoin in encrypted form that is very difficult to track.

What exactly happens when a pc gets infected by a Ransomware?
Well, earlier, ransomware software were too easy to get rid of for a little techie people who knew about windows task manager and startup items. I have personally analyzed some old ransomwares and what they did was just executed themselves and created a startup entry for their main application to show that scary screen which says that your computer or files have been locked and you need to pay some money to the attacker to get back the access to the pc. It could be easily closed by ending the ransomware process from task manager and the malicious file could easily be stopped from auto executing by running msconfig command through RUN and deleting the startup entry of the ransomware software. Some ransomware create events in windows to auto download and execute themselves even after deleting the ransomware software and these kind of ransomwares are bundled with software cracks which are actually malwares. But that too could be stopped by deleting the particular event or task from the computer.
But these days, ransomware are being coded in a much complicated way that are FUD (fully undetectable) for so many anti-virus software and the encryption technology used by the ransomware is very difficult to crack so they are getting more dangerous as they are not detectable and non-removable by any antivirus. Although some antivirus vendors like KasperSky and Malwarebytes are providing decrypting tools to recovered the locked files, there are still so many ransomware available online which decryption algorithm is still not available.

Recently "WCry", referred as "WannaCry" ransomware infected about more than 57000 computers worldwide this friday (12th May 2017) and created a panic among the computer users. It affected hospitals, schools, offices and government agencies. After infecting the computer, it's asking to pay $300 to unlock the files and I'm not sure whether the attacker really sent any decryption key to decrypt the files for anyone who paid the amount.
wannacry ransomware screen
Well, this ransomware was accidently stopped by a cybersecurity researcher which is tweeting with the user name @MalwareTechBlog. The researcher bought the domain name used by the ransomware on a website called NameCheap.com for $10.69, and set it up on a server in Los Angeles which stopped the Ransomware as the domain name used by the ransomware was never booked and setting up the domain on the server stopped the ransomware to spread.

How to prevent from getting infected with ransomware?
But still the risk is not over and the attacker might spread the ransomware again by changing the code of it and by making it more difficult to decrypt. So what can be actually done to stop the ransomware to infect your PC? Well, there is no any 100% working solution available for it yet but yes, with the few precautions, you can prevent it. I'm listing a few tips which you can follow to be safe from the ransomware:
1. Don't open any file which you receive through mail from unknown people. The file might be of any extension so don't think that you are opening a safe file and get trapped.
2. Use sandbox before opening any suspicious file which you think might not be any virus. Using a sandbox creates a virtual space in your computer and keeps your computer safe in case if you encounter any virus in your sandbox.
3. Install any good antivirus and anti-malware in your computer and keep it up to date. You may use Malwarebytes, Kaspersky, AVG Internet Security etc.
4. Apart from antivirus, you can use Anti-Ransomware tools too such as Bitdefender AntiRansomware, Malwarebytes Anti-Ransomware, EMET, Kaspersky Anti-Ransomware tool etc.
5. Disable SMB service in windows services to prevent the ransomware to be executed. To do so, open appwiz.cpl from RUN and click Turn Windows Features ON or OFF. Now look for SMB 1.0 and uncheck it and click OK. Usually you can find this option in Windows Server Edition OS.
program and features
turn windows features ON or Off
Alternatively you can run the powershell command too which is given below:
"Disable-WindowsOptionalFeature -Online -FeatureName smb1protocol"

Note: If you are sharing files among different computers, then don't turn off SMB feature. File sharing won't work after disabling this feature.

6. Install all the security patches and updates from Microsoft to keep your PC safe. TO install the important security patches, use the following links:
http://www.catalog.update.microsoft.com/Search.aspx?q=KB4012598
https://technet.microsoft.com/en-us/library/security/ms17-010.aspx

Since these too are not sufficient to prevent a user from getting infected from a ransomware so the only thing which can prevent your computer from being infected is using strong firewalls and use of common sense.

That's all for today. Keep visiting PC Tricks Guru for more tips and tricks.
Share:

Sunday, 12 March 2017

How to suspend or cancel your Jio SIM yourself

How to suspend or cancel your Jio SIM yourself
After using the free services of Reliance Jio, so many users want to suspend or cancel the Jio SIM and there are so many reasons behind it. The first reason is that users are afraid of Porting their numbers into Reliance jio because they are not sure what plans will Jio offer in future and the major problem is the network coverage. Reliance jio doesn't work in 2G/3G mode but other SIM Cards do, so usually in the areas where 4G network coverage is not so good, they won't be able to use their phone and can't make calls. Second is internet speed, I personally noticed that in most of the areas, JIO speed is very less and sometimes it doesn't work at all, even if we see full network signal indicated by the device. But with our primary networks, we can switch to 3G or even 2G in case of urgent data need. Third is frequent network drop which is happening from last few days. So overall users are not sure how will the Jio network perform that's why they don't want to switch to Jio.
Let's come back to the main topic, i.e. How to suspend or cancel your Jio SIM yourself:

  • Login to the JIO Website from the link: https://www.jio.com/Jio/portal/jioLogin (Use your login credentials of MyJio app to login)
  • Once you are logged in, you will see a settings button on the top right screen. Click on that.

How to suspend or cancel your Jio SIM yourself

  • Now you will see "Suspend and Resume" option, click on that.
  • Click on the "I would like to suspend this service" dropdown button.
  • A pop up will appear on the screen,  select any of the options, like "SIM Damaged".
  • Now click on Suspend. That's it. You will see a message that your request to suspend the service has been submitted successfully.

How to suspend or cancel your Jio SIM yourself
How to suspend or cancel your Jio SIM yourself

  • After submitting the request, your SIM will be suspended within 24 hours.

    That's it. For more tips and tricks, keep visiting PC Tricks Guru.
    Share:

    Saturday, 25 February 2017

    Customize office C2R installation for Office 2013 and 2016 with Office Deployment Tool

    Customize office C2R installation for Office 2013 and 2016 with Office Deployment Tool
    MS Office is one of the most used office suit for all the office needs worldwide and it is available in different versions (2013/16/365). In the older versions, Microsoft used MSI installers which had the option to customize the installation of office, it means we could choose which application we want to install and which we don't but in the new versions of office Microsoft we can't customize the installation because Microsoft is using click to run installer for the installation of office. If you ask Microsoft about custom installation, they would say that it's not possible but actually it is possible using the office deployment tool. So in this article I'll tell you how to customize the office installation.
    Follow the steps given below:

    1. First of all download the offline ISO file of office from office.com/myaccount or from any mirror site (I'll use office 2016 Pro Plus in this tutorial).
    2. After downloading the ISO file, mount it or extract it.
    3. Inside the ISO file, you will get one folder, "Office" and two files, "autorun.inf" and "setup.exe". Now download the office deployment tool from this link: https://www.mediafire.com/?rg6cmy7y6i18lvq
    4. After downloading the Office deployment tool, extract the file and you will get 3 files there, "Configuration.xml", "EULA" and "Setup.exe".
    5. Now open the configuration.exe in notepad and you will see some code there which is given below:
    <Configuration>
    <Add SourcePath="YOUR OFFICE INSTALLATION FILE PATH\" OfficeClientEdition="32">
    <Product ID="ProPlusRetail">
    <Language ID="en-us" />
    <ExcludeApp ID="Access" />
    <ExcludeApp ID="Groove" />
    <ExcludeApp ID="InfoPath" />
    <ExcludeApp ID="Lync" />
    <ExcludeApp ID="OneDrive" />
    <ExcludeApp ID="OneNote" />
    <ExcludeApp ID="Outlook" />
    <ExcludeApp ID="SharePointDesigner" />
    <ExcludeApp ID="Visio" />
    </Product>
    </Add> 
    6. You can edit the code as per your convenience and customize the office installation. You can replace the source path with your own path where you have kept the office installation files which you got after extracting the ISO. You can edit the value of office client edition to 32 if you want 32 bit setup and 64 if you want 64 bit setup. In the product ID value, you can type the product ID which you are using, in my case it's ProPlusRetail. In the same way, you can edit the language ID also. Now you need to decide which app you don't want to install and then add the app name in the ExcludeApp ID value. You can get the Product ID and App ID details from this documentation: https://technet.microsoft.com/en-us/library/jj219426.aspx#bkmk_productelement
    7. Once you are done with editing the xml file, save it.
    8. Now open the office deployment tool folder and press and hold the shift key and while holding the shift key, right click in the empty area of the folder and click "Open Command Window Here". Command prompt will open.
    9. Now type the following command: setup /configure configuration.xml and hit enter key.
    10. That's it. Office installation will begin and only those components will be installed which were allowed in the xml file.
    For better understanding, you may watch the video tutorial given below:


    Keep visiting for more tips and tricks.
    Share:

    Tuesday, 14 February 2017

    How to reset Microsoft Word settings to default

    How to reset Microsoft Word settings to default
    Microsoft Word is the most used word processing application worldwide and it is popular on both Windows and Mac operating systems. It is the part of the Microsoft Office package which include other essential office applications. In MS Word, sometimes we make some settings which we forget later and it disturbs the whole formatting of any new document. In this situation we need to reset the word settings to default and there is a very simple method for that but note that follow the steps which I'm giving carefully because we are going to make changes in Windows Registry and if you try to play around with it, your OS might crash and your office application might start misbehave.

    1. First of all open RUN box by pressing windows and R keys together.
    2. Now in the RUN box, type regedit and click OK. It will open registry editor.
    3. Now in the registry, navigate to HKEY_CURRENT_USER > Software > Microsoft > Office > 12 > Word and expand it.
    (The number 12 might be different as per the version of office installed in your computer)
    4. Now you should see "Data" folder there. Just right click on it and delete it.

    How to reset Microsoft Word settings to default

    5. Now open your Microsoft word, it should be rest to it's defaults and you can use it without any problems.

    Keep visiting for more tips and tricks.
    Share:

    Tuesday, 7 February 2017

    How to disable useless google apps in non rooted android phones

    How to disable useless google apps in non rooted android phones

    Disabling google apps in non rooted android phones is a big question among android phone users and personally I also don't like being forced to keep the bloatware in my phone for no reason. These days, most of the android smartphone makers have their own custom ROMs ported over android OS and they have better apps available than the default google apps but still there is no any option to uninstall the pre installed google apps like hangouts, google play music, google play movies etc and it is possible only if you root your phone but most of the android users are not so advanced to understand the TWRP recovery and ROM flashing so they are always forced to keep the bloatware in their phones.
    In this article, I'll tell you the process to disable the google bloatware in your android phone. Note that this process will not uninstall them but it will disable the bloatware and you won't be able to see their icons. Follow the steps given below:

    1. Open google play store in your phone and tap over "Help and Feedback" option.
    2. Now you will see the list of some help articles for google play. Tap over "Browse All Articles".
    3. Now tap on the article "Uninstall, disable and delete apps".

    How to disable useless google apps in non rooted android phones

    4. Once the article is open, tap over "Tap to go to application settings".
    5. Now the list of installed applications will open on the screen.
    6. Tap over the application you want to disable and then tap "Disable". If it asks to uninstall the updates, uninstall them.

    How to disable useless google apps in non rooted android phones

    7. That's it, the application will be disabled. Using the same method you can disable all the useless google bloatware which you don't need and do better memory optimization for your phone.
    Keep visiting PC Tricks Guru for more tips and tricks.
    Share:

    Wednesday, 18 January 2017

    How to search details of any person online

    How to search details of any person online
    Searching details of any person online is not an easy task and generally what people do is google the name of the person but internet is an infinite ocean where finding the exact details of any person is not so easy. But today I'll let you know about a search engines that is actually made to search people on the internet. Let's start.

    Note: These search engines use data from different social media and government servers to look for the criminal records, personal details, work details, qualifications etc. I don't assure that you will always find the correct information of any person you've been searching for. 

    This website looks like a normal search engine with two fields. In the first field, you can type the name, email, phone number or social media username and in the second field you can type the location where that person lives (that is optional, but it gives more accurate results). After entering the details, you can begin your search and it will show the person results from which you can find the person you are looking for.

    I tried searching for my details and I was amazed that how perfectly it collects that data from the internet and displays the results. Below is the list of some of the other search engines which you find useful to search the details of any person online.

    That's all for today. Keep visiting PC Tricks Guru for more tips and tricks and share the article with your friends if you like it.
    Share:

    Saturday, 31 December 2016

    How to download untouched ISO of Windows 7 with SP1

    How to download untouched ISO of Windows 7 with SP1
    Finding untouched and original ISO of Windows 7 is very difficult these days as microsoft has stopped selling the product and the download links are available only to those who purchased it through microsoft techbench or MSDN website. If you purchased Windows 7 from any physical store like BestBuy or Walmart then also you can download the ISO file from microsoft software download page by entering the product key.
    A few days ago, I was searching for fresh ISO of Windows 7 Ultimate SP1 to install it as a trial in my test machine and it was really difficult to find the ISO because microsoft has removed all the download links from its official website. DigitalRiver download links are also dead.  I tried downloading ISO from some mirror sites too but those ISOs were either modified/cracked or corrupt. The only thing which I needed was a clean ISO for Windows 7 from microsoft website only. So, at the end I had to use a javascript hack on the microsoft windows 10 download page to reveal the hidden links for Windows 7/8.1/10. If you want to know how can you download the untouched ISO of Windows 7 or any other version of Windows OS, I'll show you how can you hack the microsoft webpage and get the direct download links for Windows OS download.

    IMPORTANT UPDATE:
    As the download links have been removed from the Microsoft page, I am providing you the latest direct download links for Windows 7:

    The below-mentioned trick has been patched and is not working anymore. So use the links I provided above to download the latest ISOs of Windows 7

    1. The first thing you need to do is open the Windows 10 ISO Download page (Click Here)
    Note: Please read the note given at the end of the page.
    2. Now wait for a few seconds and let the webpage load completely. Once the webpage is loaded completely, click on "MORE DOWNLOAD OPTIONS"
    windows ISO download page
    4. Now open the developer tools in your browser (press ctrl+shift+I keys together in chrome browser) and click on the "Console" which will show a console area where you can type codes.
    5. Now copy the code given below and paste in the developer console in the browser and press Enter key.
    var _0x5c09=["product-edition","getElementById","innerHTML","<option value='' selected='selected'>Select edition</option><option value='28'>Windows 7 Starter SP1 </option><option value='2'>Windows 7 Home Basic SP1 </option><option value='6'>Windows 7 Home Premium SP1 </option><option value='4'>Windows 7 Professional SP1 </option><option value='8'>Windows 7 Ultimate SP1 </option><option value='48'>Windows 8.1 and Pro Single Language (Autumn 2014 update)</option><option value='52'>Windows 8.1 and Pro (Autumn 2014 update) </option><option value='79'>Windows 10 Home and Pro th1</option><option value='82'>Windows 10 Single Language Home and Pro th1</option><option value='178'>Windows 10 Home and Pro (1511 th2 Apr 2016 update) </option><option value='184'>Windows 10 Single Language (1511 th2 Apr 2016 update) </option>","submit-product-edition","Confirm","log"],_0x1d62=[_0x5c09[0] ,_0x5c09[1] ,_0x5c09[2] ,_0x5c09[3] ,_0x5c09[4] ,_0x5c09[5] ,_0x5c09[6]] ,edititonbox=document[_0x1d62[1]](_0x1d62[0]);edititonbox[_0x1d62[2]]=_0x1d62[3] ,document[_0x1d62[1]](_0x1d62[4])[_0x1d62[2]]=_0x1d62[5] ,console[_0x5c09[6]];
    If your code worked, the you should see a message function log() { [native code] } in the console area.
    apply javascript hack in console
    6. Now click on the dropdown menu of Select Edition and that's it, you can see the list of Windows 7/8.1 and 10 editions. Select your desired OS and click CONFIRM.
    download for windows 7 untouched iso
    7. Now select the language and then click CONFIRM.
    8. You will be redirected to another page where you can see the download buttons for 32 bit and 64 bit both.
    windows 7 ultimate SP1 ISO download links
    9. Click on any of the links as per your requirement and download will begin. ISO files are large in size so you can use Internet Download Manager to download the ISO with resume support.
    I'm including a video tutorial for the whole process for better understanding.
    I hope you liked the post. Keep visiting for more tips and tricks and subscribe to my newsletter to get early updates.

    Update (20th Feb 2017): It seems that microsoft has changed the webpage for windows 10 ISO download so if you open the link, it will give you the option to download Media Creation Tool only. But no need to worry, all you need to do is to use this chrome extension https://chrome.google.com/webstore/detail/mobile-browser-emulator/lbofcampnkjmiomohpbaihdcbjhbfepf?hl=en and open the page in the mobile emulator, the page will show you the options to choose the OS version from dropdown. Rest of the things are same as mentioned in the tutorial.

    Update (11th Feb 2019): New links have been updated in the post. Download Windows 7 ISO using the links given in the post.
    Share:

    Thursday, 29 December 2016

    Get Free Rs.200 Cash With Snapdeal Refer and Earn Program

    Get Free Rs.200 Cash With Snapdeal Refer and Earn Program
    Hi friends, snapdeal is one of the most popular E-Commerce site in India and it has introduced a very good refer and earn program in which you can earn free cash to buy things from Snapdeal or recharge your phone using freecharge. The process is very simple as it's name suggests, "Refer and Earn". The only thing you have to do is refer your friends to install the app using your referral code and when they sign up, you will get Rs.200 and your friend gets Rs.100 too on making their first purchase from snapdeal. So here is how you can do it:

    1. Install snapdeal from the link given : DOWNLOAD FROM HERE
    2. After installing the app, if it asks for referral code, enter Ashutohd2i and then sign up for an account.
    3. After sign up, you will get Rs.100 free SD Cash which you can use to purchase anything from snapdeal and if any of your referred friend installs it and makes his/her first purchase, you get Rs.200 extra.
    Note that if the app is being installed for the first time in your phone, then only you will get the free Rs.100 credit otherwise you won't get anything.

    Isn't it simple? So start referring your friends to install snapdeal and keep earning (upto 25 referrals only)
    Share:

    Tuesday, 27 December 2016

    How To Show Indian Holidays in MIUI 8 Calendar

    miui
    MIUI is one of the best Android ROM developed by Xiaomi. MIUI has so many unique and great featured and looks and feel of MIUI is very satisfying. I heard most of the users complaining that MIUI 8 calendar is not showing Indian holidays so I thought I should write an article to show that how can we show indian holidays in MIUI calendar. Just follow the steps below:

    1. First of all you need to sign into Google calendar and enable the "Holidays in India" calendar. Make sure to use the same gmail email address which you have used in your phone to sign into your gmail app or playstore.

    google calendar

    2. Now in your phone, install google calendar from play store and open it.
    3. After opening the google calendar, tap on the top left menu to open the sidebar and check what information you want to display in your calendar like Birthdays, Holidays etc.

    enable holidays in google calendar

    4. Now open MIUI calendar and from the top right corner, tap on menu and then SETTINGS.

    miui calendar settings

    5. Now enable the option "Show Holidays" and then from "Events in Calendar" option, select your preferred email and check the option "Holidays in India".

    Show Indian Holidays in MIUI 8 Calendar

    6. That's it. Now if you open the MIUI calendar, you will be able to see color dots on the holiday dates. If you tap on the date, it will show the holiday details under the agenda.

    Indian Holidays in MIUI 8 Calendar

    Keep visiting for more tips and tricks.
    Share:

    Custom Search Box

    Blog Archive

    Contact Form

    Name

    Email *

    Message *