Excel office skills: Excel form permission setting, this method is powerful

How to do it in excel can only be input, not modified. According to the editor's understanding, it should be conditional and cannot be modified, what if the input is wrong for the first time? The following editor will give the students an example that can no longer be modified after "review".

First, the effect demonstration

1. You entered the sales record in the form

2. The colleague in charge of "audit" opens your form, checks it correctly, and selects "audited" in column E.

3. You can also add new records, but when you want to modify an "audited" record, a warning will pop up and make it impossible for you to modify it.

4. If you want to delete "audited", you can modify it. But the reality is cruel, you must enter the permission password before you can change it.

Second, the implementation steps:

1. Select the E column area, data-data validity-allow "sequence", and enter "audited" in the box below. This step can generate a menu that can be selected in the E column.

2. Select the E column area, review-allow the user to edit the area-add the area and password.

3. Select the input area of ctrl+1 D, open the cell formatting window, and protect-cancel the tick before "locking".

4. Select the input area A2:D14 of column D, data-validity-Custom-enter the formula in the following formula box:

= LEN ($E2) = 0

5. Click "error warning" and enter the title and warning content.

6. Finally protect the worksheet

At this point, the operation is complete!

The security of the basic functions of Excel is still limited. If you want to achieve complex functions, you still have to rely on VBA to complete.

This article comes from the network. If it is inconvenient, please contact me to delete it.