You can also set the protection for changing the file modify (however it can be easily hacked as well). While saving the document in a usual way ( “File” – “Save as”).Įnter your password in a new dialog box and re-enter it to ensure there are no mistakes in your password The second way to set a password is not harder than the first one. It can be hacked literally in a matter of seconds. Keep in mind, that book, pages and VBA macros protection are not secure in all Excel versions. You can also use “Info” menu to set the password protection for the book and file pages. It’s the most reliable way of protection, since it’s the hardest to hack. You’ve just protected your file from opening by encrypting its content with a password. This way you’ll ensure there are no mistakes in your password. When you finished working with your document.Īs the new window appears, enter your password in it, press OK and enter it one more time. They’re not evident though, but fairly easy. There’re two ways of setting a password on an Excel file. How to set, remove and recover a password to open a file in Excel 2010-2016 Setting a password on an Excel 2007-2019 file If you entered one or both passwords, click “OK,” re-enter the password or passwords when prompted, click “OK” again and then click the “Save” button.Don’t like wasting time? Watch this 2-minute video right now. If you want Excel to prompt for write access, enter a password in the “Password to modify:” field.Ĭlick the “OK” button to close the dialog box and then click “Save” to save the file with the changes. If you want Excel to prompt for a password to open the file, enter a password in the “Password to open:” field.
When someone accesses the file, Excel will display a prompt advising the user that the workbook should be opened as read-only unless changes are necessary.Īdd passwords if you want Excel to prompt for a password before allowing a user to open or modify the workbook file. Click the “File” tab on the ribbon and select “Save As” from the menu to open the Save As dialog box.Ĭlick the “Tools” button and select “General Options” from the drop-down menu to open the General Options dialog box.Ĭlick the box next to the “Read-only recommended” option.
0 kommentar(er)
