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 !!

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

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.

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\""

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.

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.

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.