Many of the data in the worksheet are generated by formula calculations, so how can you let others see the results of a calculation and hide the formula you use? Today we are going to introduce you to use macros to solve this problem.
First, create macros
Start Excel, select Tools-Macros-record new macros, enter the name of the macro in the open window, and set the save in item to personal Macro Workbook,
How do I hide worksheets
In actual work, it is often necessary to hide some important worksheets, however, a lot of friends in the hidden worksheet, is the menu "format/worksheet/hidden" to complete, do not know how to hide the worksheet, for a few people who know Excel, is basically a fake, because we can also use th
Excel protects passwords to prevent others from modifying Excel documents, but sometimes you forget them.
Crack method:
Open the Excel document that needs to be cracked, then press ALT+F11 to open the VBA editor, click Insert-Module, copy the following code in the module, do not need to save, press F5 to run, wait for run complete. About 2 minutes to wait, th
Many of my friends who often come into contact with office documents at work or study may have encountered this. It is really terrible to forget the password in some password-added documents. In particular, some important documents can cause people to crash. However, there is no limit to human power. Today, we have introduced two gadgets for the world of different dimensions. They can easily crack the passw
without exception. Let's take a look at the four big Excel password cracking tools.
Excel password Crack tool of the four great King Kong
1, Accent OFFICE Password Recovery
Features: Successfully cracked passwords will be recorded for the next crack, crack ha
Tools1. One computer (Microsoft Excel is installed)2. Protected Excel OneSteps1, first, open the protected Excel table, press "ALT" + "F11" key, pop up the following interface.2, click "Insert"--"module", appearsAdd the following code to the empty space: Public Sub allinternalpasswords ()'Breaks Worksheet and Workbook
1. Open the Excel file for password cracking;2. Click the tool --- macro on the menu bar to record the new macro and enter the macro name, for example, AA;3. Stop recording (in this way, an empty macro is obtained );4. Click the tool --- macro-macro on the menu bar, select AA, and click the edit button;5. Delete All characters (only a few characters) in the window and replace them with the following content
For those who do not want to be seen, many people like to encrypt Excel files, but if not for a long time, you may have forgotten the password. Excel file forgot password What should I do?
Excel password files, recommended using
Method 1,If you have a password, you can directly open "tools" in excel -- "protection" -- "undo workbook protection" and enter the password in the pop-up window.Method 2,If there is no password, we can use the macro module to crack it. Let's take a look at the specific process.1. Open
The password for an Excel document is the most complex of all Office products, with the most password types and also involves a high-fidelity VBA password. Naturally Excel Password Cracking Tool Results dialog box is also slightly
Often with Office software to deal with the person must know, if the password of the encrypted document is equivalent to scrap the file, it will be a terrible thing. But mankind is omnipotent, today for you to introduce a software, you can loosen the Word and Excel password, solve your worries. This tool is the Office Passwor
Everyone in the use of office2010 to make Excel tables do not know how to set the Excel table data partition password, in fact, the method is very simple oh, as long as the Office2010excel table in the new area and then select the partition can be set up the password Oh, Let's take a look at the following with small kn
Method One: Third party office Password remover Software
Through the loss of data we will guide the use of Third-party data recovery software to repair, and the password has forgotten, we can also collect third-party tools to crack the password way to solve. Here we recommend that you use the office2003 version:
1. Open an encrypted EXCEL File2 tool --- macro ---- recording new macro --- input name such as aa3. Stop recording (an empty macro is obtained)4 tools --- macro ---- macro. Select aa and click Edit.5. Delete All characters (only a few characters) in the window and replace them with the following code.6. Close the editing window.7 Tools --- macro ----- macro, select AllInternalPasswords, run, OK twice !!!It will take 2 minutes to complete the process
Although Excel encryption cannot prevent people who can open it from leaking through copying and other operations, it is at least a good defense line. To remove the password protection for Excel 2013, click "Office" and then "Save as". In the displayed "Save as" dialog box, click "Tools" in the lower left corner, select "general options": the "general options" di
Excel2003 Tutorial 41, locking cells and encrypting in Excel.
Demo Animation
Operation Steps
When multiple people edit the same workbook document, we can encrypt the worksheet in order to prevent modification of the data that is filled by others.
Start Excel, open the appropriate workbook document, and perform the tools → protect → allow users to edit
Microsoft query definitions can be saved in a file with an extension of qdy, and after you open a Qdy file to read external data, Excel defaults to saving the query definition and data in an Excel file. When you update the data, just refresh the data (click the "Refresh All" button). If there is no "refresh All" button, click on the Menu "Tools"-"Custom", tick "external data" can be selected.
The new query
There are times when we need to view the contents of certain areas in the Distributed Excel worksheet. However, the protection settings for worksheets are only for the entire worksheet. Do you have a limited way to view some of the data areas by password? Yes, please follow the small weave to practice together!
The fo
Excel pops up "The cell or chart you are trying to change is protected and therefore read-only." To modify a protected cell or chart, use the Undo Sheet Protection Command (in the Change group on the Review tab) to unprotect it. You may be prompted to enter a password. window, as shown in Figure 1.
In this case, how should we solve it? After research, two methods of solving
How to set a password for an excel file1. Click to enter the "file" menu, and then click "save as" on the left;2. In the pop-up "save as" window, click "tools" in the lower left corner, and select "general options ";3. In this case, a dialog box is displayed, "Open permission password" and "change p
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.