Skip to main content

Unprotect/ Unhide worksheets in excel workbook

  • Right click on file
  • Open with any ZIP editor (WinZip, WinRAR, 7-zip)
  • Locate xl\workbook.xml, 
  • Edit using any text editor, 
  • Search for workbookProtection 
  • Just delete whole line including < >
  • Save!

Like delete below whole code:

<workbookProtection workbookAlgorithmName="*******" workbookHashValue="***" workbookSaltValue="*****" workbookSpinCount="****" lockStructure="***"/>

Comments

Post a Comment

Popular posts from this blog

Gujarati/Family relations

Gujarati/Family relations - Wikibooks, open books for an open world In Gujarati culture: These are the "titles" for family members. With the exception of Father, Mother, and Grandparents (who are called by the title only), all of these titles are added after the name of the person. Father: Papa or Bapuji Mother: Ba, Mummy or Maa Brother (also male cousins): Bhai (e.g. Haresh Bhai) Brother's Wife: Bhabhi (e.g. Komal Bhabhi) Sister (also female cousins): Ben (e.g. Mayuri Ben) Older Sister: Didi (e.g. Mayuri Didi) Sister's Husband: Banevi or Jijaji (e.g. mahesh Jijaji) Father's Younger Brother: Kaka (e.g. Rajesh Kaka) Father's Younger Brother's Wife: Kaki (e.g. Komal Kaki) Father's Older Brother: Kaka(e.g. Jiten Kaka) Father's Older Brother's Wife: Kaki (e.g. Bhavna Kaki) Father's Oldest Brother: Mota Kaka(e.g. Jiten Kaka) Father's Oldest Brother's Wife: Moti Kaki (e.g. Bhavna Kaki) Father's Sister: Foi,Fui (also ...
3 comments
Read more

How to turn off Xiaomi "Don't cover the orange area" or "Don't cover the earphone area"

If you get the “Don’t cover the orange/earphone area of the screen” message when you turn on your phone’s screen all the time, it means that you’ve turned on the Prevent pocket dial feature and something is blocking the proximity sensor at the top part of your phone. Sometimes it's quite annoying and simple one-time solution is to press volume up & back button at a time to disable. Infact Prevent pocket dial is a good feature that prevents you from rejecting or picking up calls by accident when the phone is in your pocket by using the proximity sensor. If this feature isn’t working properly on your Xiaomi phone, the check whether anything is blocking area next to earphone where proximity sensor is placed. Mostly it caused by screen guard. You should remove it. If you still facing problem then here’s how to turn it off: 1. From your device’s Settings, tap Lock screen & password. 2. Slide the Prevent pocket dials switch to the off position. (Slider will be greye...
Post a Comment
Read more

Disable Google Chrome extensions auto update

Disabling extension update: Edit preferences json-file for Google Chrome on Windows:  C:\Users\<USERNAME>\AppData\Local\Google\Chrome\User Data\Default\Preferences on Ubuntu for Chromium:  ${HOME}/.config/chromium/Default/Preferences In this file find the extension preferences block and set  "update_url"  property like  "http://localhost"  for example. For now according to given url updating of that extension is simply impossible. To locate that preferences block use extension id which you can find at  chrome://extensions/  page with "Developer mode" enabled. In simpler words, open "Preferences" file with wordpad and replace "update_url":"https://clients2.google.com/service/update2/crx" with   "update_url":"https://localhost" source:  https://productforums.google.com/d/msg/chrome/l3zOZeO-5-M/Y7VaR0KCWNIJ Disable all Google Chrome updates: 2.1. Any OS Just type  chrome://p...
1 comment
Read more