Our Source Document is shown below. We have used the Slice theme, in this document, so we would like to prevent other users from changing this theme since this would totally change the look and formatting of our document. The same guidelines for creating a strong password should be followed, for Word documents, in terms of the password should contain numbers, letters, and punctuation marks, however, for the purposes of this example we have kept the password simple.
Click on the drop-down arrow and select Restrict Editing. Firstly, click the button to Stop Protection. The way one does this is in the Formatting restrictions section, clicking on Settings ………..
Lastly to complete the process totally, uncheck the Limit formatting to a selection of styles, in order to not be limited to certain styles either, and then close the Restrict Editing Panel.
We would now like to ensure that only certain sections of the Word document can be edited. We check the Allow only this type of editing in the document: option and make sure that No changes Read Only are selected from the drop-down list.
We could also add users specifically, by clicking on More users…….. Click on the button to stop protection. Enter the password which in this case was SettingTwo and click Ok. Uncheck Exceptions and Allow Only this type of editing in the document: option and then close the Restrict Editing Panel. The whole document can now be freely edited. Click on the drop-down arrow and choose Restrict Editing.
Make sure Exceptions are not checked. Enter a password, in this case, it is WholeDocument and then click Ok. And there you have it the whole document is now protected and cannot be edited unless the user enters the specified password.
Excel provides ways for data to be protected in worksheets, as well as the overall structure of the workbook. Word also has options for protecting data and preventing changes from being made to whole documents or just certain sections. These options allow for control over sensitive data or information. In a sample workbook, allow users to only be able to select unlocked cells when protecting your worksheet. Tags: Spreadsheet in excel. Taryn is a Microsoft Certified Professional, who has used Office Applications such as Excel and Access extensively, in her interdisciplinary academic career and work experience.
She enjoys showcasing the functionality of Excel in various disciplines. She has over ten years of experience using Excel and Access to create advanced integrated solutions. This kind of protection can be easily breached by VBA and thus is in not way safe. However, that is something one has to live with when facing a situation where user input is needed. A better way to save Excel files from unwanted editing is by encrypting it so that a person who does not know the password for the workbook cannot even open it, or can only open it as a read-only file.
This kind of protection cannot be broken by VBA or any other means. It can be done by accessing the General Options in the Save As dialog window. Hi Agnius Thank you for your comment.
Point taken. However, these are topics tested in many Excel exams and there is often confusion since workbook level is actually protecting the worksheet structure, so it was in that context that the tutorial was made and made in order to address those issues. Also while I agree with you that encryption and VBA also play a role in more advanced level protection I will do another tutorial on the more advanced level options When trying this out, I protected a workbook, saved it, but was still able to edit it and resave without having to put in a password or even unprotect it.
So, what does Protect Workbook do and what are the Structure and Windows options for. Thanks, Dan. Switch to the worksheet you want to protect. Unlock any cells you want users to be able to change: select each cell or range, click Cells on the Format menu, click the Protection tab, and then clear the Locked check box.
Hide any formulas that you don't want to be visible: select the cells with the formulas, click Cells on the Format menu, click the Protection tab, and then select the Hidden check box. Unlock any graphic objects you want users to be able to change. You don't need to unlock buttons or controls for users to be able to click and use them.
You can unlock embedded charts, text boxes, and other objects created with the drawing tools that you want users to be able to modify.
To see which elements on a worksheet are graphic objects, click Go To on the Edit menu, click Special, and then click Objects. Hold down CTRL and click each object that you want to unlock. Click the Protection tab. Clear the Locked check box, and if present, clear the Lock text check box. On the Tools menu, point to Protection, and then click Protect Sheet.
Type a password for the sheet. Note The password is optional; however, if you don't supply a password, any user will be able to unprotect the sheet and change the protected elements. Make sure you choose a password you can remember, because if you lose the password, you cannot gain access to the protected elements on the worksheet.
In the Allow all users of this worksheet to list, select the elements that you want users to be able to change. Click OK, and if prompted retype the password. Give specific users access to protected ranges You must have Windows to give specific users access to ranges. This command is available only when the worksheet is not protected. Click New. In the Title box, type a title for the range you're granting access to.
In the Range password box, type a password to access the range. The password is optional; if you don't supply a password, any user will be able to edit the cells. Click Permissions, and then click Add. Locate and select the users to whom you want to grant access. If you want to select multiple users, hold down CTRL while you click the names. Click OK twice, and if prompted retype the password. Repeat the previous steps for each range for which you're granting access. To retain a separate record of the ranges and users, select the Paste permissions information into a new workbook check box in the Allow Users to Edit Ranges dialog box.
In the Protect Sheet dialog box, make sure the Protect worksheet and contents of locked cells check box is selected, type a password for the worksheet, click OK, and retype the password to confirm. Note A sheet password is required to prevent other users from being able to edit your designated ranges.
Protect workbook elements and files Protect workbook elements On the Tools menu, point to Protection, and then click Protect Workbook. Do one or more of the following: a.. To protect the structure of a workbook so that worksheets in the workbook can't be moved, deleted, hidden, unhidden, or renamed, and new worksheets can't be inserted, select the Structure check box.
To protect windows so that they are the same size and position each time the workbook is opened, select the Windows check box. To prevent others from removing workbook protection, type a password, click OK, and then retype the password to confirm it.
Protect a shared workbook If the workbook is already shared, and you want to assign a password to protect the sharing, unshare the workbook. Have all other users save and close the shared workbook. If other users are editing, they will lose any unsaved work. Unsharing the workbook deletes the change history.
If you want to keep a copy of this information, print out the History worksheet or copy it to another workbook. In the When box, click All. Clear the Who and Where check boxes. Select the List changes on a new sheet check box, and then click OK. To print the History worksheet, click Print. To copy the history to another workbook, select the cells you want to copy, click Copy , switch to another workbook, click where you want the copy to go, and click Paste.
Note You may also want to save or print the current version of the workbook, because this history might not apply to later versions. For example, cell locations, including row numbers, in the copied history may no longer be current.
0コメント