Monday, April 24, 2017

What the 'Win' Key Does - Shortcuts!

You might think that the little windows or ‘win’ key  on your keyboard only has one function – to bring up the start menu – but it in fact can be used in conjunction with other keys for a vast number of simple shortcuts. These ‘win’ key  shortcuts will save you those precious minutes and help you perform tasks you never knew you could with your PC.
Enjoy the following listed shortcuts, according to alphabetical order.


  1. Win — opens the Start Menu (but in Windows 8.1 it opens the previous window)
  2. Win + A — opens Windows 10’s Action Center
  3. Win + B — chooses the first icon in the Notification Area (then use the arrow keys to switch icons)
  4. Win + Ctrl + B — switches to a new message in the Notification Area
  5. Win + C —brings up the Charm Bar (in Windows 8 and 8.1). In Windows 10 it opens Cortana
  6. Win + D — shows the desktop and minimizes all windows
  7. Win + E — opens Windows Explorer. In Windows 10 opens Quick Launch
  8. Win + F — starts ’Find files and folders’
  9. Win + Ctrl + F — opens ’Find computers’
  10. Win + G — brings all gadgets to the foreground (in Windows 7 and Vista); opens Windows 10’s Game bar
  11. Win + K — opens a new Start menu (only Windows 8 and 8.1)
  12. Win + L — changes user or can lock the workstation
  13. Win + M — minimizes all your windows
  14. Win +  Shift + M — restores windows that have been minimized
  15. Win + O — locks device orientation (and disables gyroscope function on tablets);
  16. Win + P — switches operating modes to an outside monitor or projector
  17. Win + Q — opens Search charm for installed apps (in Windows 8)
  18. Win + R — opens the ’Run dialog’ box
  19. Win + T — opens the Taskbar
  20. Win + U — opens the Utility Manager
  21. Win + W — opens Windows Ink Workspace
  22. Win + X — opens the Windows Mobile Application Center (only mobile computers in Windows Vista and 7);
  23. Win + Y — starts Yahoo! Messenger
  24. Win + Pause — opens My Computer
  25. Win + F1 — opens Windows Help
  26. Win + 1 ... 0 — runs or switches to the program pinned to the Taskbar with a specific sequence number 
  27. Win +  Shift + 1 ... 0 — starts a new program pinned to the Taskbar with a specific sequence number 
  28. Win + Ctrl + 1 ... 0 — switches to the last active window of the program that’s pinned to the Taskbar with the specific sequence number 
  29. Win + Alt +1 ... 0 — opens the transitions list for the program pinned to the Taskbar with the specific sequence number 
  30. Win + ↑ — maximizes the active window
  31. Win + ↓ — restores the default window size or minimizes active windows
  32. Win + ← or → — switches the window deployment mode
  33. Win +  Shift + ← or → — switches a window between monitors in multi-monitor set-ups 
  34. Win +  Shift + ↑ or ↓ — stretches the active window from the top to the bottom of the screen and restores the window size
  35. Win + Home — minimizes or restores all non-closed windows, except active ones (only Windows 7), goes to the top of the web page
  36. Win + Space — looks at the desktop (only Windows 7). Changes the layout (only Windows 8 and 10)
  37. Win + + — activates the Magnifier Utility or zooms the image by 100%
  38. Win + — — if the Magnifier Utility is active, the image is reduced by 100%
  39. Win + Esc — disables the Magnifier Utility
Fill free to add more shortcuts, I know there are many more !!

Tuesday, April 18, 2017

Set Password to multiple Excel file in current and subfolder

' Code to add Password to Excel file.
' Note: This will set password to non-password without prompting, but the file already have the password will get prompt to enter old password before it set new one.

Public Sub addPassword()
    Dim FSO As Object
    Dim folder As Object, subfolder As Object
    Dim wb As Object

    Set FSO = CreateObject("Scripting.FileSystemObject")
    folderPath = ActiveSheet.Range("A1").Value ' you can hardcore the path or put it in the cell
    pwd = ActiveSheet.Range("B1").Value ' you can hardcore the password or put it in the cell

    Set folder = FSO.GetFolder(folderPath)
    
    With Application
        .DisplayAlerts = False
        .ScreenUpdating = False
        .EnableEvents = False
        .AskToUpdateLinks = False
    End With
    
' loop to get root files of the mention folder path..

    For Each wb In folder.Files
        If Right(wb.Name, 3) = "xls" Or Right(wb.Name, 4) = "xlsx" Or Right(wb.Name, 4) = "xlsm" Then
            Set masterWB = Workbooks.Open(wb)
            ActiveWorkbook.SaveAs Filename:=Application.ActiveWorkbook.FullName, Password:=pwd
            ActiveWorkbook.Close True
        End If
    Next

' following loop is used to get files from "n" numbers of subfolders... 

    For Each subfolder In folder.SubFolders
        For Each wb In subfolder.Files
            If Right(wb.Name, 3) = "xls" Or Right(wb.Name, 4) = "xlsx" Or Right(wb.Name, 4) = "xlsm" Then
                Set masterWB = Workbooks.Open(wb)
                ActiveWorkbook.SaveAs Filename:=Application.ActiveWorkbook.FullName, Password:=pwd
                ActiveWorkbook.Close True
            End If
        Next
    Next
    With Application
        .DisplayAlerts = True
        .ScreenUpdating = True
        .EnableEvents = True
        .AskToUpdateLinks = True
    End With
End Sub


Thursday, April 13, 2017

Fix Out of Sync Audio in VLC with a Keyboard Shortcut

I was watching movie, on VLC player,  and there was problem with video and voice sync. I have found some shortcut on internet that fix my problem, and here I am sharing with you too.

A very simple keyboard shortcuts to fix this problem. While you're watching the video, just press the J or K keys to move the audio back or forward 50 milliseconds, respectively. Quick, easy, and no advanced fiddling required.

Wednesday, March 1, 2017

Add Notepad Application to the Windows Desktop Right-Click Menu

Copy following lines into notepad and save with .reg extension


Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Directory\Background\shell\Notepad]
[HKEY_CLASSES_ROOT\Directory\Background\shell\Notepad\command]
@="\"C:\\Windows\\System32\\notepad.exe\""


Thursday, October 13, 2016

Happiness Quotes!

Received in mail from a friend and want to add it in my blog, Credit got to writer.

Happiness is a mental or emotional state of well-being characterized by positive or pleasant emotions ranging from contentment to intense joy.


  • “People are just as happy as they make up their minds to be.”
  • “I'm choosing happiness over suffering, I know I am. I'm making space for the unknown future to fill up my life with yet-to-come surprises.”
  • “Happiness is not the absence of problems, it's the ability to deal with them.”
  • We become more successful when we are happier and more positive.
  • The grand essentials to happiness in this life are something to do, something to love, and something to hope for.
  • Only one thing has to change for us to know happiness in our lives:  where we focus our attention.
  • We learn the inner secret of happiness when we learn to direct our inner drives,  our interest and our attention to something outside ourselves.
  • Now and then it's good to pause in our pursuit of happiness and just be happy.
  • Happiness belongs to the self-sufficient.
  • Happiness is the meaning and the purpose of life, the whole aim and end of human existence.
  • Tell me what you feel in your room when the full moon is shining upon you  and your lamp is dying out, and I will tell you how old you are, and I shall know if you are happy.
  • Happiness is living by inner purpose, not by outer pressures.
  • Every gift from a friend is a wish for your happiness.
  • It’s a helluva start, being able to recognize what makes you happy.
  • The secret of happiness is not in doing what one likes, but in liking what one does.
  • There are short-cuts to happiness, and dancing is one of them.
  • The art of being happy lies in the power of extracting happiness from common things.
  • While we are focusing on fear, worry, or hate, it is not possible for us to be experiencing happiness, enthusiasm or love.
  • Happiness is good health and a bad memory.
  • To be happy, drop the words 'if only' and substitute instead the words 'next time'.
  • It is only possible to live happily ever after on a day to day basis.
  • Growth itself has the germ of happiness.
  • Delight in mediation and solitude. Compose yourself, be happy. You are a seeker.
  • Happiness comes when your work and words are of benefit to yourself and others.
  • May everyone be happy and safe, and may their hearts be filled with joy.
  • To enjoy good health, to bring true happiness to one’s family, to bring peace to all, one must first discipline and control one’s own mind. If a man can control his mind  he can find the way to Enlightenment, and all wisdom and virtue will naturally come to him.

Friday, October 7, 2016

Create User Define Function and Macro as an Add-in


We work lot in excel and manage our work with functions and macros. I am here creating the process that will save your time and effort to re-create again and again the same functions or macros.

Here we are going to create Add-in that will automatically load when you open your excel, and the function will be available all the time. So let's start.

Step 1: Quickly create an empty add-in for excel


  1. Open excel and Save a blank workbook as a Excel Add-In (*.xlam) in your Add-In folder (%UserProfile%\AppData\Roaming\Microsoft\AddIns)
  2. I named it PersonalAddIn.xlam (Save it with any name you like)
  3. Click Office button.
  4. Click "Excel options" button.
  5. Click "Add-Ins" tab.
  6. Select "Excel Add-ins" from manage dropdown list and click GO
  7. Click "Browse" button
  8. Select the (.xlam) file that you just saved in step 1
  9. Click OK (Make sure you enable)



Step 2: Add custom functions and macros to your personal add-in

  1. Go to the Developer Tab on the ribbon.
  2. Click "View Code"
  3. Click on the project panel you see VBAProject (*.xlam)
  4. Click Insert Menu --> Module
  5. Copy and paste custom functions and macros to code window.


That's it... we are done.

Step 3: Use your user define function

  1. Go to the cell
  2. Click "Insert Function" in formula bar
  3. Select category "User Defined"
  4. Select your custom function
  5. Click OK


Step 4: Use your user define Macro

  1. Go to "Developer" tab
  2. Click "Macros" button
  3. Select/Type the macro name
  4. Click "Run"


Hope this will help you in you daily work, In case of any query you can write to me. Thanks for reading.

Wednesday, October 5, 2016

Windows Registry Tips

A small tweak which disables processing of autorun.inf to protect your PC from usb autorun viruses.

Windows Registry Tips

Remove Language Bar from Taskbar
[-HKEY_CLASSES_ROOT\CLSID\{540D8A8B-1C3F-4E32-8132-530F6A502090}]
@="Language bar"
"MenuTextPUI"="@%SystemRoot%\\System32\\msutb.dll,-325"


Allow Internet Explorer 7+ to open direct links to swf files (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BLOCK_LMZ_SCRIPT]
"iexplore.exe"=dword:00000000


Disable the Turn off computer button on the Welcome screen (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System]
"shutdownwithoutlogon"=dword:00000000

Disable USB Autorun to Save PC from USB Viruses (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\IniFileMapping\Autorun.inf]
@="@SYS:DoesNotExist"

Disable Writing to USB Drives (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\StorageDevicePolicies]
"WriteProtect"=dword:00000001

Enable Writing to USB Drives (XP/Vista/7)
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\StorageDevicePolicies]
"WriteProtect"=dword:00000000

Note: Modifying the registry can cause serious problems that may require you to reinstall your operating system. Use the information provided at your own risk.