Archive for the ‘Others’ category

« Older Entries
Newer Entries »

How to Enable Old / Vertical Volume Control in Windows 10

January 23rd, 2017 by Admin

When you click the volume icon in the system tray, a new horizontal volume slider will appear on the screen. It just feels a little weird that you have to adjust the volume horizontally. Luckily there is simple registry hack that can help you get back the old / vertical volume control back in Windows 10.

new-volume-control

How to Enable Old / Vertical Volume Control in Windows 10?

  1. Press the Windows key + R shortcut to open the Run command box. Type regedit and press Enter.

    regedit-via-run

  2. When the Registry Editor window opens, navigate to the following key:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\MTCUVC

    If the MTCUVC key doesn’t exist, right-click on CurrentVersion and then choose New -> Key. Name the new key MTCUVC.

    new-registry-key

  3. Select the MTCUVC key on the left pane. Right-click any empty space on the right pane, then choose New -> DWORD (32-bit) Value.

    new-dword-value

  4. Name this new DWORD EnableMtcUvc and leave the Value data to be 0. If you want to enable the new / horizontal Volume Control later, just change its data back to 1.

    EnableMtcUvc

  5. Log out of your Windows account and log back in. Click the Volume icon in the system tray and you should see your old vertical Windows mixer.

    old-volume-control

    Actually, this tweak might work instantly without having to log out or restart your PC.

Comments Off on How to Enable Old / Vertical Volume Control in Windows 10 »

Posted in Others, Tips & Tricks, Windows 10

Tags:

4 Options to Rename One or Multiple Worksheet Tabs in Excel

January 23rd, 2017 by Admin

How can I rename multiple worksheets at one time using VBA code? In Excel, you can assign a unique name to each sheet tab in your workbook so you can easily find the tab you want. In this tutorial we’ll show you 4 simple methods to rename one or multiple worksheet tabs in Excel.

Note: The name of a worksheet tab can have a maximum of 30 characters only.

Option 1: Rename worksheet tab with the “Rename” shortcut menu

Right-click on a specific tab you want to rename. You can see many options coming up when you right click. From there, choose the Rename shortcut menu.

worksheet-rename-menu

Type a name that you want to give to the worksheet tab and press Enter. Repeat this procedure for each tab you want to rename.

type-new-name-for-worksheet

Option 2: Rename worksheet tab by double-clicking the tab

Another way to rename a worksheet tab in Excel is by double-clicking on the sheet tab. When you double-click on the worksheet tab at the bottom, the tab name (e.g. Sheet1) is highlighted. After that, you just have to type the new name.

double-click-sheet-to-rename

Option 3: Rename worksheet tab using keyboard shortcut

Select the worksheet tab that you want to rename, then press the keyboard shortcut Alt + O + H + R (Just press these 4 keys on the keyboard one by one in the sequence), type a name and press Enter.

Option 4: Rename multiple worksheet tabs using VBA code

It could be a time-consuming task if you use the above methods to rename lots of worksheet tabs. To simplify the job, you can rename multiple worksheet tabs using VBA code.

  1. After opening your Excel workbook, press the Alt + F11 shortcut to open Visual Basic Editor. Right-click on VBAProject on the left pane and choose Insert -> Module to insert a new module.
  2. Copy the following VBA code and paste it to the right pane of the VBA editor (“Module1” window). Click the Run menu, and select Run Macro.

    Sub RenamingSheets()
    nmbr = InputBox("What's the first number you want to name the sheets?", "Renaming Sheets")
    For ws = 1 To Worksheets.Count
    Sheets(ws).Name = "KB" & nmbr
    nmbr = nmbr + 1
    Next ws
    End Sub

    rename-sheet-with-vba

  3. All your worksheet tabs will be quickly renamed with new names like “KB1”. You can change the VBA code to rename worksheet to what you want.

    multiple-sheets-renamed

Comments Off on 4 Options to Rename One or Multiple Worksheet Tabs in Excel »

Posted in Others, Tips & Tricks

Tags:

Restore Missing “Extract All” Option to ZIP Right-Click Menu

January 17th, 2017 by Admin

Windows has built-in native support for ZIP files. When you right-click on a .zip file in Windows Explorer, the “Extract All” option from context menu allows you to extract all contents of the zip file to a folder of your choice.

If the “Extract All” option is missing or overridden by third-party zip/unzip software, you can restore it with a registry hack in Windows 10 / 8 / 7 / Vista.

How to Restore Missing “Extract All” Option to ZIP Right-Click Menu?

This registry hack requires you to log into Windows as administrator. Follow these steps:

  1. Download this REG file (add_extract_all_context_menu.reg) and save it to a folder where you can find easily. Tips: the .reg file is actually a text file and you can view the content using NotePad.
  2. After the download is complete, double-click on the .REG file. Click Run if prompted by Security Warning.
  3. Registry Editor will confirm if you want to import the registry settings in your .reg file, click Yes.

    add-extract-all-context-menu

  4. Once it’s done, right-click on a .zip file and the “Extract All” option will show up in the Explorer’s right-click context menu.

If you want to remove the “Extract All” option from Explorer’s right-click menu, you can run this .reg file (remove_extract_all_context_menu.reg) instead. That’s all there is to it.

Comments Off on Restore Missing “Extract All” Option to ZIP Right-Click Menu »

Posted in Others, Tips & Tricks, Windows 10, Windows 7, Windows 8, Windows Vista

Tags:

6 Quick Ways to Open Settings App in Windows 10

January 12th, 2017 by Admin

PC Settings is a touch-friendly app introduced since Windows 8, which is created to replace the classic Control Panel. The option to change Windows password is not available in Control Panel, and now you have to change it through PC Settings. In this tutorial we’ll show you 6 quickest ways to open Settings app in Windows 10.

windows-10-pc-settings

Method 1: Press WIN + I Hotkey to Open the Settings app

Just press the Windows + I shortcut keys together on your keyboard. This should be the fastest way to open the Settings app in Windows 10.

Method 2: Open the Settings app from Start Menu

Click the Start button. When the Start Menu appears, click the Settings icon (a little gear icon directly above the Power icon) near the menu’s bottom-left corner. The Settings app will launch immediately.

open-settings-via-start-menu

Method 3: Open the Settings app via Cortana Search

Click the Cortana Search box in the taskbar and type settings. Once the search results are loaded, click the Settings modern app.

open-settings-via-cortana

Method 4: Right-click Taskbar to Open the Settings app

Right-click on any empty space on Windows 10 taskbar, and then select Settings from the context menu.

open-settings-via-taskbar

Method 5: Open the Settings app in Windows 10 from Command Prompt

Open the Command Prompt (or PowerShell) in Windows 10. Type the following command at the Command Prompt.
start ms-settings:

open-settings-from-cmd

Once you press Enter, Windows 10 will instantly launch the Settings app.

Method 6: Open the Settings app in Windows 10 from Run

Press the Windows key + R to open the Run command box. Type ms-settings: and press Enter. This will open the Settings app immediately.

open-settings-via-run

Comments Off on 6 Quick Ways to Open Settings App in Windows 10 »

Posted in Others, Tips & Tricks, Windows 10

Tags:

How to Change Active / Inactive Title Bar Color in Windows 10

January 10th, 2017 by Admin

Don’t like white title bar in Windows 10? By default, the title bar is white for both active window and inactive window. In this tutorial we’ll show you how to change the active / inactive title bar color in Windows 10.

Part 1: Change Active Title Bar Color in Windows 10

  1. Right-click on any empty space on the desktop, select Personalize from the context menu.

    personalize

  2. When the Settings window opens, click Colors on the left side.
  3. On the right side, pick an accent color and turn on the “Show color on title bar” setting.

    show-color-on-title-bar

When it’s done, Windows 10 will display your selected color for the title bar of any active window. But inactive title bar remains white as usual.

Part 2: Change Inactive Title Bar Color in Windows 10

Unfortunately there is no option to change the color of inactive title bar in the Settings app, and you have to change it using this registry hack:

  1. Press the Windows key + R to open the Run command box. Type regedit and hit Enter.

    regedit-via-run

  2. Once the Registry Editor opens, navigate to the following key:
    HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\DWM
  3. Right-click the DWM key on the left side, select New -> DWORD (32-bit) Value from the context menu.

    registry-new-dword

  4. Name the new DWORD value as AccentColorInactive. Then double-click on AccentColorInactive on the right side. In the popup window, type the RGB value of the color of your choice under Value data box and click OK. You may need to google the RGB value of your preferred color.

    AccentColorInactive

  5. Close Registry Editor. You’ve successfully changed the title bar color for inactive window.

Comments Off on How to Change Active / Inactive Title Bar Color in Windows 10 »

Posted in Others, Tips & Tricks, Windows 10

Tags:

How to View or Restrict the Number of Connections in SQL Server

December 30th, 2016 by Admin

SQL Server allows a maximum of 32,767 user connections. In this tutorial we’ll show you how to find out the number of connections to a database in SQL Server, and restrict the number of connections to a SQL Server instance.

Part 1: View Total Number of Connections in SQL Server

Need to check the number of active connections for each database? This can be done easily using the following script. The script displays the databaseName, the number of connections and the login name:

SELECT DB_NAME(dbid) as DBName,
loginame,
COUNT(dbid) as NumberOfConnections
FROM sys.sysprocesses
WHERE dbid > 0
GROUP BY dbid, loginame

If you’re running SQL Server 2012, 2014 or 2016, run this script instead:

SELECT DB_NAME(database_id) as DBName,
login_name,
COUNT(session_id) as NumberOfConnections
FROM sys.dm_exec_sessions
GROUP BY database_id, login_name

Part 2: Restrict Concurrent Database Connections in SQL Server

To configure the maximum user connections, open SQL Server Management Studio and connect to your database, then follow these steps:

  1. In Object Explorer, right-click a server and click Properties.

    sql-server-properties

  2. Click the Connections node on the left page.
  3. Under Connections, in the Maximum number of concurrent connections box, type or select a value from 0 through 32767 to set the maximum number of users that are allowed to connect simultaneously to the instance of SQL Server.

    max-connections-in-sql-server

  4. Click OK. Restart SQL Server to apply your changes.

Comments Off on How to View or Restrict the Number of Connections in SQL Server »

Posted in Others, SQL Server, Tips & Tricks

Tags:

5 Ways to Open Run Command Box in Windows 10

December 30th, 2016 by Admin

The Run command box provides the quickest way to launch programs (for instance, Registry Editor, Group Policy Editor) or open folders and documents. In this tutorial we’ll show you 5 ways to open Run command box in Windows 10.

run-command-box

Method 1: Open Run Command Box by Pressing WIN + R

Just press the Windows key and the R key at the same time, it will open the Run command box immediately. This method is the fastest and it works with all versions of Windows.

Method 2: Open Run Command Box from Start Menu

Click the Start button (the Windows icon in the lower-left corner). Select All apps and expand Windows System, then click Run to open it.

open-run-from-start-menu

Method 3: Open Run Command Box Using Cortana Search

Type the word run inside Cortana’s search box in the taskbar, and then click Run from the search result.

open-run-via-cortana-search

Method 4: Open Run Command Box from Power User Menu

Press the Windows key + X keyboard shortcut (or right-click on the Start button). When the Power User menu appears, click Run.

open-run-from-winx-menu

Method 5: Open Run Command Box from Command Prompt

Open a Command Prompt in Windows 10. Copy and paste the following command and press Enter.
explorer.exe Shell:::{2559a1f3-21d7-11d4-bdaf-00c04f60b9f0}

open-run-from-cmd

It will show the Run dialog box immediately.

Comments Off on 5 Ways to Open Run Command Box in Windows 10 »

Posted in Others, Tips & Tricks, Windows 10

Tags:

Fix: “User must change password at next logon” option greyed out in Windows

December 29th, 2016 by Admin

When you try to change or reset the password of a user account, you might find the checkbox “User must change password at next logon” is greyed out, so you can’t choose this option.

user-must-change-password-next-logon

In this tutorial we’ll show you how to enable the “User must change password at next logon” option that is greyed out for Windows local or domain user account.

For Windows Local Accounts:

Open the Computer Management. Expand System Tools, then Local Users and Groups, then Users. Right-click on your local account and select Properties from the context menu.

local-account-properties

This will open the Properties dialog box. Uncheck the “Password never expires” box and you’ll then find the “User must change password at next logon” option is enabled. Click Apply and then OK.

windows-password-never-expires

For Active Directory User Accounts:

In Windows Server with Active Directory installed, open the Active Directory Users and Computers MMC snap-in (start->run->dsa.msc). Right-click on your domain user and select Properties.

domain-account-properties

Click the Account tab. Under the Account options section, uncheck the “Password never expires” checkbox and click OK.

domain-password-never-expires

Now you should be able to reset the password and force the domain user to change it at next login.

Comments Off on Fix: “User must change password at next logon” option greyed out in Windows »

Posted in Active Directory Password, Others, Tips & Tricks, Windows 10, Windows 7, Windows 8, Windows Vista, Windows XP

Tags:

3 Ways to Change Network Location to Public or Private in Windows 10

December 27th, 2016 by Admin

The first time you connect to a network, you’ll be prompted to turn on sharing and connect to devices. Turn on this settings will set your network location to private. A private network makes your computer discoverable to other PCs. If you don’t want to share musics, pictures, videos or even printers with other PCs on the network, you should set the network type to public. In this tutorial we’ll show you 3 ways to change network location to public or private in Windows 10.

network-location-type

Method 1: Change Windows 10 Network Location Using Group Policy

  1. Press the Windows key + R to open the Run box. Type secpol.msc and press Enter.

    secpol

  2. When the Local Security Policy window opens, click Network List Manager Policies in the left pane. Double-click on the name of the current network connection in the right pane.

    network-list-policies

  3. Click the Network Location tab at the top. Under the Location type, you can choose either Private or Public.

    private-public-network-location

  4. Click Apply and then OK to save your change.

Method 2: Change Windows 10 Network Location Using Registry Editor

  1. Press the Windows key + R to open the Run box. Type regedit and press Enter.
  2. In the left pane of Registry Editor, navigate to the key:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\NetworkList\Profiles
  3. Expand the Profiles key in the left pane. Click on each subkey and have a look if the ProfileName matches the name of your current network connection.

    network-profile-name

  4. If you have found the right subkey, double-click the Category in the right pane and edit the DWORD to the value you want. Public: 0, Private: 1, Domain: 2.

    network-profile-category

  5. Reboot your computer to apply the new network location.

Method 3: Change Windows 10 Network Location Using PowerShell

  1. Open PowerShell in Administrator mode.
  2. Type or paste the following command in the PowerShell and press Enter. It will list the name and properties of your active network connection. In my example, the network name is TLRouter.
    Get-NetConnectionProfile

    get-network-profile

  3. Type the following command and press Enter to change your network location to private. Replace TLRouter with your network name.
    Set-NetConnectionProfile -Name "TLRouter" -NetworkCategory Private

    change-network-location-via-powershell

    If you want to change the network location to public, type this command instead:
    Set-NetConnectionProfile -Name "TLRouter" -NetworkCategory Public

Comments Off on 3 Ways to Change Network Location to Public or Private in Windows 10 »

Posted in Others, Tips & Tricks, Windows 10

Tags: