Excel is a software that has become indispensable in today’s workplace. It is used for everything from simple calculations to complex financial models. With such important work stored in Excel files, it’s important to protect them from unauthorized access and modification. In this article, we will discuss different ways to protect Excel files.
Cara Memproteksi Workbook (Proteksi Level Workbook) Pada File Excel
One way to protect an Excel file is by setting a workbook protection level. Here are the steps to do that:
- Open the Excel file you want to protect. Click on the “Review” tab in the ribbon.
- Click on the “Protect Workbook” option in the “Changes” group.
- Select “Protect Current Sheet” or “Protect Structure and Windows” depending on your needs.
- Enter a password in the “Password to unprotect workbook” field.
- Click “OK” and re-enter the password to confirm.
By setting a workbook protection level, users will not be able to make any changes to the Excel file without entering the correct password.
3 Cara Mengunci Excel, Memproteksi File dengan Password
Another way to protect an Excel file is by password-protecting it. Here are three different ways you can do that:
- Open the Excel file you want to protect. Click on “File” in the ribbon, and then click on “Protect Workbook” and choose “Encrypt with Password”.
- Enter a password in the “Password” field and click “OK”.
- Re-enter the password to confirm it and click “OK”.
- To remove the password protection, repeat the above steps and delete the password in the “Password” field.
You can also use VBA code to password-protect an Excel file. Here’s how:
- Hit Alt-F11 to open the VBA editor.
- Insert a new module by clicking on “Insert” in the menu bar and then selecting “Module”.
- Paste the following code in the new module:
Sub PasswordMacro()
'Updateby20140526
Dim x As Integer
Dim y As Integer
Dim z As Integer
On Error Resume Next
x = Application.InputBox("Enter the password you want to use for this workbook.", "Enter Password")
y = Application.InputBox("Re-Enter password to confirm.", "Confirming the password")
z = Application.InputBox("How many worksheets are there in this workbook?", "Worksheet Count")
For i = 1 To z
ActiveWorkbook.Sheets(i).Protect Password:=x, UserInterfaceOnly:=True
Next
End Sub - Click on “File” in the menu bar and then select “Save As”.
- Select “Excel Macro-Enabled Workbook” from the “Save as type” drop-down menu.
- Choose a location to save the file and click “Save”.
- Close the VBA editor.
- Click on “Developer” in the ribbon and select “Macros”.
- Select the “PasswordMacro” macro and click “Run”.
- Enter and confirm the password, and specify the number of worksheets in the workbook.
Finally, you can use third-party software like Kutools for Excel to password-protect an Excel file. Here’s how:
- Download and install Kutools for Excel from their website.
- Open the Excel file you want to protect and click on “Protect Workbook” in the ribbon.
- Select “Kutools” and then click “Protect Workbook”.
- Enter a password in the “Password” field and click “OK”.
- To remove the password protection, click on “Protect Workbook” in the ribbon and select “Kutools”. Then click on “Unprotect Workbook” and enter the password.
6+ Cara Memproteksi File Microsoft Excel Tidak bisa Dibuka,DiEdit, Copy
Aside from password protection and workbook protection levels, there are several other ways to protect an Excel file from unauthorized access, editing, and copying. Here are six additional ways you can do that:
- Use a digital signature to make sure that the file has not been tampered with. Click on “File” in the ribbon and then select “Info”. Under “Protect Workbook”, click on “Add a Digital Signature”. Follow the steps to create and apply your digital signature.
- Hide and lock cells that contain sensitive information. Select the cells you want to lock, right-click on them and select “Format Cells”. In the “Protection” tab, check the “Locked” box and click “OK”. Then click on “Review” in the ribbon and select “Protect Sheet”. In the “Protect Sheet” dialog box, check the “Select locked cells” box and enter a password if desired.
- Use “Track Changes” to monitor changes to the Excel file. Click on “Review” in the ribbon and select “Track Changes”. Choose the options you want to track, such as changes to comments or formatting, and click “OK”. Excel will now highlight any changes made to the workbook.
- Use a data validation rule to restrict input in certain cells. Select the cell you want to restrict and click on “Data” in the ribbon. Select “Data Validation” and choose the criteria for the cell. For example, you can allow only numbers or dates, or set a range for acceptable input.
- Use “Permissions” to restrict who can access and edit the Excel file. Click on “File” in the ribbon and then select “Info”. Under “Protect Workbook”, click on “Protect Sharing”. Choose the options you want, such as allowing only certain users to make changes to the workbook.
- Use “Digital Rights Management (DRM)” to protect your Excel file. DRM is a technology that encrypts files and controls access to them. You can use a third-party tool like Locklizard to apply DRM protection to your Excel file.
Cara Memproteksi File Workbook di Microsoft Excel – Iis Istiqomah
Iis Istiqomah, a Microsoft Excel instructor, has shared her own method of protecting Excel files. Here are the steps:
- Open the Excel file you want to protect.
- Click on “File” in the ribbon and then select “Save As”.
- Choose “Excel Binary Workbook” from the “Save as type” drop-down menu.
- Click “Save”.
- Close the Excel file and reopen the binary workbook you just saved.
- Click on “File” in the ribbon and then select “Info”.
- Click on “Protect Workbook” and choose “Encrypt with Password”.
- Enter a password in the “Password” field and click “OK”.
- Save the file and close it.
According to Iis, this method provides better protection against Excel password cracking tools.
Cara Memproteksi File Microsoft Excel dengan Password
We have already discussed several ways to password-protect an Excel file, but here are some additional tips to make sure your password protection is effective:
- Use a strong password that is at least eight characters long and contains a mix of uppercase and lowercase letters, numbers, and symbols.
- Don’t use easily guessable passwords such as “123456” or “password”.
- Change your passwords frequently.
- Don’t share passwords with others or write them down where anyone can find them.
- Don’t use the same password for different Excel files.
FAQ
1. What is the difference between workbook protection and password protection in Excel?
Workbook protection sets a password to prevent users from modifying the structure of the workbook, such as adding or deleting worksheets. Password protection, on the other hand, sets a password to prevent users from opening or changing the contents of the workbook.
2. Are there any Excel files that cannot be password-protected?
Yes. Password protection does not work for Excel files that are saved in the CSV or XML format. To protect these files, you will need to use a different method such as encryption or digital rights management.
