Archive for the ‘Others’ category

« Older Entries
Newer Entries »

2 Ways to Hide or Unhide Worksheet in Excel 2016 / 2013 / 2010 / 2007

December 14th, 2016 by Admin

Is there a way to prevent others from viewing a sheet in an Excel workbook? If you don’t want people to change data or formula in a cell, you can hide the sheet. But this shouldn’t be used as a security measure. In this tutorial we’ll show you 2 ways to hide / unhide worksheet in Excel 2016 / 2013 / 2010 / 2007.

Note: Excel doesn’t let you hide all sheets in a workbook. At least one has to be displayed.

Method 1: Hide/Unhide Excel Worksheet with GUI

  1. Right-click on the worksheet you want to hide, select Hide from the pop-up menu. Your worksheet will no longer be visible, however, the data contained in a hidden worksheet can still be referenced on other worksheets.

    hide-sheet

  2. To unhide a worksheet, just right-click on any visible worksheet and select Unhide.

    unhide-sheet

  3. In the Unhide dialog box, you can see all of the currently hidden sheets in the list box. Select a sheet you want to unhide and click OK.

    excel-hidden-sheets

Method 2: Hide/Unhide Excel Worksheet with VBA

Excel has a more secure setting known as “Very Hidden”. A very hidden worksheet can’t be unhidden using the Excel user interface because it doesn’t appear in the Unhide dialog box. Here’s how to hide / unhide a worksheet with VBA editor:

  1. To open the VBA editor, press the Alt+F11 keyboard shortcut, or right-click on any worksheet and select View Code.

    excel-view-code

  2. From the Project window in the upper left pane, you can see all hidden and visible sheets in your workbook. Select a sheet you want to hide.
  3. In the lower left pane, you can see all properties of your selected worksheet. In the Visible drop-down list, select xlSheetVeryHidden.

    xlSheetVeryHidden

  4. Close the VBA editor. Your worksheet will no longer be visible. When the Very Hidden attribute is set on a worksheet, the Hide option is greyed out.

    excel-unhide-greyed

  5. Very hidden sheets can only be made visible through the VBA editor. If you want to unhide a very hidden sheet, open the VBA editor and change the Visible attribute back to xlSheetVisible.

Comments Off on 2 Ways to Hide or Unhide Worksheet in Excel 2016 / 2013 / 2010 / 2007 »

Posted in Others, Tips & Tricks

Tags:

2 Ways to Prevent Excel Sheet from Being Deleted

December 13th, 2016 by Admin

How can I protect an Excel worksheet from being deleted? Looking for a way to prevent sheets from being deleted while still allowing them to be hidden or rearranged? In this tutorial we’ll show you 2 ways to protect a particular or all sheets from being deleted in Excel 2016/2013/2010/2007.

Tips: If you want to protect an Excel file (.XLS, .XLSX) from being deleted accidentally, please try the Protect My Folders program which can lock any folders or files with password.

Method 1: Protect Entire Workbook Structure with Password

  1. Open your Excel workbook. Select “Review” Ribbon menu and click “Protect Workbook” from the changes group.

    protect-workbook

  2. A Protect Structure and Window dialog box opens. Make sure the Structure option is checked. Type your password and click OK.

  3. Reenter the password and click OK.
  4. Now all your sheets in the workbook are protected. You cannot insert, delete, rename, move, copy, hide or unhide worksheets anymore.

Method 2: Protect A Particular Sheet from Being Deleted Using VBA

If you just want to prevent users from deleting a particular sheet you designate, try this solution. This works flawlessly for me on a test workbook in Excel 2016.

  1. Right-click on any sheet tab and select View Code from the popup menu. This will open the Visual Basic Editor (ALT+F11).

    sheet-view-code

  2. You’ll see a list of worksheets on the left. Double-click on every sheet you want to protect from being deleted, copy and paste the following code into the large white area on the right.

    Private Sub Worksheet_Deactivate()
    ThisWorkbook.Protect , True
    Application.OnTime Now, "UnprotectBook"
    End Sub

    sheet-vba-code

  3. Right-click on Microsoft Excel Objects on the left, select Insert -> Module.

    insert-excel-module

  4. Double-click on the newly-created module on the left. Copy and paste the following code into the right pane.

    Sub UnprotectBook()
    ThisWorkbook.Unprotect
    End Sub

    module-vba-code

  5. Click Save and you’re done. If you’re using a macro-free workbook, you’ll get the warning message “The following features cannot be saved in macro-free workbook“. Click No.

    cannot-macro-free-workbook

  6. In the Save As dialog box, select “Excel-Macro Enabled Workbook (*.xlsm)” and click Save.

    macro-enabled-workbook

  7. When you see the popup message “Be careful! Parts of your document may include personal information that can’t be removed by the Document Inspector“, click OK.

    document-inspector-warn

  8. Close all of your opened windows. Open the .xlsm file in Excel, right-click your protected sheet tab and select Delete, next click Delete to confirm, you’ll see the failure message: Workbook is protected and cannot be changed.

    workbook-is-protected

  9. That’s all there is to it.

Comments Off on 2 Ways to Prevent Excel Sheet from Being Deleted »

Posted in Others, Tips & Tricks

Tags:

2 Ways to Repair Corrupted or Damaged RAR / ZIP Files

December 2nd, 2016 by Admin

When trying to extract files from RAR/ZIP archive, you might come across the error message like “CRC32 failed”, “Checksum error”, “Unexpected end of archive”, etc. How to fix and extract corrupted archive?

zip-archive-corrupted

It’s quite common to get a corrupted RAR/ZIP file when you download it from the Internet with low or unstable Internet connection. Try downloading the file again and it may resolve the issue. When a redownload is not possible, you have to look for ways to repair the RAR/ZIP file. In this tutorial we’ll show you 2 ways to repair a RAR or ZIP archive whether it’s damaged, corrupted or partially downloaded.

Method 1: Repair Corrupted or Damaged RAR/ZIP File Using WinRAR

Before get started, you need to download and install WinRAR on your computer. If you don’t have a licensed copy of WinRAR, you can download a free evaluation copy which gives you about 40 days to try it out.

  1. Right-click on your corrupted RAR or ZIP file and select “Open with WinRAR” from the context menu.
  2. When WinRAR opens, click the Tools menu and select Repair archive.

    repair-archive

  3. Click the Browse button to select the destination location where the repaired RAR/ZIP file has to be saved. Leave the archive type as what it was and click OK.

    save-repaired-archive

  4. After WinRAR has completed repairing the archive, click the Close button.

    rar-zip-archive-repaired

    You’ll see a repaired archive created in the same folder as the corrupted archive.

Method 2: Extract Broken RAR/ZIP Archive

Unfortunately, after repairing RAR/ZIP archive, WinRAR may still say the file is corrupt. Then you can attempt to extract the content in the RAR/ZIP archive. WinRAR has an option to extract broken files using which you can actually extract the broken or corrupt files – ignoring all the errors no matter what.

  1. Double-click your corrupted RAR or ZIP archive to open it in WinRAR. Click Extract to in the toolbar at the top.
  2. Choose the destination folder where you want to extract the files. But most importantly, you have to check the Keep broken files option under the Miscellaneous section.

    winrar-keep-broken-files

  3. Click OK and wait while the files are extracted. Eventually you’ll have all the files present in your RAR/ZIP archive.

Conclusion

So that is how you can repair corrupted or damaged RAR/ZIP files. Of course, there are also many third-party RAR/ZIP repairing utilities available on the net, but I won’t recommend them as most tools might have even lower recovery rate than WinRAR.

Comments Off on 2 Ways to Repair Corrupted or Damaged RAR / ZIP Files »

Posted in Others, Tips & Tricks

Tags:

How to Fix “Cannot Start / Open Microsoft Outlook”

December 2nd, 2016 by Admin

Cannot start Microsoft Office Outlook, unable to open the Outlook window? Outlook stuck on the “Load Profile” window? This can happen when your Outlook profile or Outlook data files have become corrupted or damaged. In this tutorial we’ll show you how to fix these issues by making a copy of Outlook profile.

Tips: If Outlook cannot start because your Outlook PST file is corrupt, you can check this how to repair PST article . If Outlook prompts you to enter PST password but you’ve forgotten it, you can recover PST password with this method: Recover Forgotten Password for Outlook Data File (.PST).

How to Fix “Cannot Start / Open Microsoft Outlook”?

  1. Open the Control Panel and set the View by option to Large icons. Click Mail (32-bit).

    mail-applet

  2. This will open the Mail Setup window. Click the Show Profiles button.

    show-outlook-profiles

  3. You should see the default profile called Outlook. Highlight it in the list and click Copy. (If you are told to make a new profile because your profile is corrupt, click the Add button to proceed).

    copy-outlook-profile

  4. Type a name for the new profile and click OK.

    type-new-profile-name

  5. Under the option of “When starting Microsoft Office Outlook, use this profile“, choose the first option (or select the new profile from the drop-down list and make Outlook automatically open that profile). Click Apply and then OK.

    enable-outlook-profile-prompt

  6. Now restart Outlook application. When prompted for a profile to be used, choose your new profile and click OK.

    choose-profile-when-outlook-start

    Outlook will start with all your email, contacts and other data intact.

A Outlook profile is made up of email accounts, PST data files, contacts, calendars and preferences. If making a copy of your existing Outlook profile doesn’t fix your problem, you might need to create a new profile and set up your email accounts from scratch.

Comments Off on How to Fix “Cannot Start / Open Microsoft Outlook” »

Posted in Others, Tips & Tricks

Tags:

Display Full Path in Title Bar of Windows 10 File Explorer

November 26th, 2016 by Admin

By default, Windows 10 will display the folder name alone in the title bar of File Explorer. Sometimes you might need to know the absolute path of the location you are currently in. In this tutorial we’ll show you 2 ways to make Windows 10 display full path (file location) in the title bar of File Explorer.

Method 1: Make Windows 10 Display Full Path in Explorer Title Bar Using Folder Options

  1. Open File Explorer. Click the View tab on the ribbon. You’ll see the the Options button on the right-hand side. Click it to open the Folder Options dialog.

    open-folder-options

  2. Click the View tab. Locate and tick the checkbox named “Display the full path in the title bar“.

    display-full-path-in-the-title-bar

  3. Click Apply followed by OK. Log off your user or restart the computer. As you see, the File Explorer should now show the full file path instead of the folder name in the title bar.

    file-explorer-display-full-path

Method 2: Make Windows 10 Display Full Path in Explorer Title Bar Using Registry Editor

  1. Press the Windows key + R to open the Run dialog box, type regedit and hit Enter.

    regedit-via-run

  2. In the left pane of Registry Editor, navigate to the following key:
    HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\CabinetState
  3. In the right pane, double-click the value entry FullPath and modify the value to 1.

    display-full-path-in-explorer-titlebar

    If FullPath doesn’t exist, you need to create it first. To do so, right-click on the empty space and select New -> DWORD (32-bit) Vaule, and name it FullPath.

  4. Close Registry Editor and reboot your computer. If you want to make Windows 10 not show full path in the title bar of File Explorer, just open Registry Editor and delete the FullPath value entry.

Comments Off on Display Full Path in Title Bar of Windows 10 File Explorer »

Posted in Others, Tips & Tricks, Windows 10

Tags:

2 Options to Disable BitLocker on Surface Pro 4

November 22nd, 2016 by Admin

Surface Pro comes with BitLocker encryption enabled by default. Many Surface Pro users don’t realize that BitLocker was turned on until they get locked out of Windows 10, or be asked for a recovery key during advanced boot up. In this tutorial we’ll show you 2 simple methods to turn off / disable BitLocker on Surface Pro 4 running Windows 10.

Option 1: Disable BitLocker from Settings

  1. Press the Windows key + I to open the Settings screen, or click the Settings icon from Windows 10 Start Menu.

    open-settings-app

  2. Click on System.

    system-settings

  3. Click About on the left side. From the right side, scroll down to the Device encryption section and click Turn off button.

    turn-off-device-encryption

  4. A pop-up window will open, saying “If you turn off device encryption, your files won’t be protected, and decryption can take a long time“. Just click Turn off button to proceed.

    disable-device-encryption

Option 2: Disable BitLocker from Control Panel

  1. Open the Control Panel in Large icons view. Click BitLocker Drive Encryption.

    bitlocker-drive-encryption

  2. Click the Turn off BitLocker link where it appears next to your drive.

    turn-off-bitlocker

  3. Click Decrypt all drives to begin the decryption process.

    decrypt-bitlocker-drives

How to Know if Your Drive is Decrypted?

BitLocker decryption is running in the background and you won’t be informed when it’s complete. Depending on the amount of data on your drive, it can take several hours to get the job done. To check out the decryption progress, open an elevated Command Prompt and run the following command:

manage-bde -status

bitlocker-status

This will display the Bitlocker stauts for all disks. In this example, the conversion status shows my OS drive is fully decrypted. If the decryption is still in progress, the conversion status will shown as “Decrytpion in Progress”, and you need to wait for “Percentage Encrypted” reaches 100%.

Comments Off on 2 Options to Disable BitLocker on Surface Pro 4 »

Posted in Others, Tips & Tricks, Windows 10

Tags:

Change PIN Complexity Requirements Policy in Windows 10

November 22nd, 2016 by Admin

PIN login was first introduced in Windows 8 that lets users to login with a four-digit number. The PIN is really short and simple that could be compromised easily by hackers.

Thankfully, Windows 10 includes the PIN complexity feature that allows to set up a complex PIN with special characters, uppercase / lowercase letters. The PIN isn’t restricted to four digits and it can be as complex as Windows text-based password. In this tutorial we’ll show you how to change / enable the PIN complexity requirements policy in Windows 10.

Part 1: Enable PIN Complexity Group Policy in Windows 10

  1. Press the Windows key + R keyboard shortcut, type gpedit.msc in the Run box and press Enter. This will open the Local Group Policy Editor.

    gpedit

  2. Navigate to the following location on the left side:

    Computer Configuration > Administrative Templates > System > PIN Complexity

    If you’re running Windows 10 Anniversary Update (version 1607) or earlier, navigate to:

    Computer Configuration > Administrative Templates > Windows Components > Windows Hello for Business > PIN Complexity

  3. On the right side, you can see 8 different policies to customize PIN complexity. Note that changing PIN complexity does not impact existing PIN login, only affects new PIN created.

    pin-complexity-policy

    • Require digits: Your PIN must contain at least one digit number.
    • Require lowercase letters: Your PIN must contain at least one lowercase letter.
    • Require uppercase letters: Your PIN must contain at least one uppercase letter.
    • Expiration: This policy lets you set the number of days before the PIN expires and forces users to change PIN.

      pin-expiration

    • Maximum PIN length: This policy lets you set a maximum number of characters you can use to create a PIN.
    • Minimum PIN length: Determine the least number of characters that a PIN may contain. This should be less than the Maximum PIN length.

      minimum-pin-length

    • History: Prevent you from reusing previously used PINs. You can configure Windows to remember 0 to 50 history PINs.
    • Require special characters: Your PIN must contain at least one of these special characters: ! ” # $ % & ‘ ( ) * + , – . / : ; < = > ? @ [ \ ] ^ _ ` { | } ~ .

      pin-special-chars

  4. Once you are done setting up the PIN complexity, restart Windows 10 to make your changes take effect. Now when you try to set up a new PIN, you can see the “PIN requirements” link under the PIN box. Click the link and you can view the PIN complexity requirements configured on your computer.

    pin-requirements

Part 2: Use Registry Editor to Enable PIN Complexity in Windows 10

If you are running Windows 10 Home edition, then you’re unable to access the Local Group Policy Editor. In that case you can use the Windows Registry Editor to enable PIN complexity.

  1. Press the Windows key + R keyboard shortcut, type regedit in the Run box and press Enter. This will open the Registry Editor.

    regedit-via-run

  2. Navigate to the following key on the left side:
    HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\PassportForWork\PINComplexity

    If the PINComplexity key doesn’t exist, you need to create it manually.

  3. On the right side, you can create separate DWORD values for each PIN complexity policy. For example, if you want to set the PIN to expire after 30 days, right-click the empty space and select New -> DWORD (32-bit) Value, name the newly-created value as Expiration. Double-click on it, enter 30 (Decimal) in the Value Data box and click OK.

    PINComplexity

    • Digits: Require digits
    • Expiration: Expiration
    • UppercaseLetters: Require uppercase letters
    • LowercaseLetters: Require lowercase letters
    • MaximumPINLength: Maximum PIN length
    • MinimumPINLength: Minimum PIN length
    • SpecialCharacters: Require special characters
  4. If you don’t want to enforce one of PIN complexity policies, just delete the corresponding DWORD value and you’re done. After you complete editing the registry, reboot Windows 10 to apply the new PIN complexity policy.

Comments Off on Change PIN Complexity Requirements Policy in Windows 10 »

Posted in Others, Tips & Tricks, Windows 10

Tags:

Customize Critical & Low Battery Level and Action in Windows 10

November 17th, 2016 by Admin

Need to change alert level of low battery on your laptop? No low battery level warning message and your computer always just shuts off? You won’t lose your unsaved documents if you set your computer to go into hibernation when reaching the critical-battery level. In this tutorial we’ll show you how to customize the critical & low battery level and action in Windows 10.

How to Customize Critical & Low Battery Level and Action in Windows 10?

  1. Open the Control Panel with Large icons view. Click Power Options.

    power-options

  2. Click the Change plan settings link next to the power plan that is currently selected for your laptop or tablet.

    change-power-plan

  3. Click the Change advanced power settings link at the bottom.

    advanced-power-settings

  4. When the Power Options dialog box shows up, click the “Change settings that are currently unavailable” link at the top to edit all power settings. Expand the Battery section in the list and you can find various battery settings.
  5. Expand the Critical battery action, you can select Hibernate, Sleep or Shutdown for both On battery and Plugged in. Expand the Low battery action and you can have the computer do nothing when the low battery level is reached.

    critical-battery-action

  6. Expand the Critical battery level, you can adjust the battery power percentage to 3% or higher. There is also corresponding option to change the low battery level.

    critical-battery-level

  7. When it’s done, click OK to save your changes. If you have messed up the settings, just click the Restore plan defaults button at the bottom and your critical & low battery level and action will be restored to default.

Comments Off on Customize Critical & Low Battery Level and Action in Windows 10 »

Posted in Others, Tips & Tricks, Windows 10

Tags: