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.