- WHAT TO DO WHEN MICROSOFT WORD SELECTION IS LOCKED HOW TO
- WHAT TO DO WHEN MICROSOFT WORD SELECTION IS LOCKED PASSWORD
Click OK, and then close the dialogue boxes to continue." SO, when I go into Word, it says: "The command cannot be performed because a dialogue box is open. I have the same problem as a few other people here. If this does not solve your problem, please e-mail me at with contact details as Microsoft are keen to get further information to investigate the problem and resolve it.
WHAT TO DO WHEN MICROSOFT WORD SELECTION IS LOCKED HOW TO
The text explaining how to do this can be found at, however to explain a bit more, here are a few pictures and words.
WHAT TO DO WHEN MICROSOFT WORD SELECTION IS LOCKED PASSWORD
Step 6: After creating the range password successfully, select the Protect Sheet button and protect the whole worksheet with a password.Īt last, when you select the locked cells, you can see a pop-out prompt for you to enter the range password for changing the cells.I was contacted by Gerald who had this problem and after a bit of research I found the answer. Tips: To select the referred cells, you can click the up arrow to select cells in the sheet or directly input the cells’ locations. Don’t forget to click OK to save the change. Then enter the range name, referred cells and range password in the box. Step 5: Choose New in the pop-out prompt. Step 4: Click the Review option in the upper panel and choose the Allow Edit Ranges button. Steps 1-3 are the same as those of the Way 1 above.
For example, you want the users just to fill in their own parts in your sheet. It can be applied when you hope the user edit some of the locked cells. Lock Certain Cells Using the Extra Range Passwordīesides the normal whole sheet password, this method provides an extra password for users to unlock the cells. Step 5: Enter a password to unprotect the worksheet and confirm it.Īfter that, if the locked cells are clicked, a box will be popped out to remind that the cells are protected.Ģ. Step 4: Locate to the tool menu > choose Review > select Protect Sheet. Step 3: Select the cells that you plan to lock and right-click them to choose Format Cells and tick the Locked option in the Protection window. Step 2: Switch to the Protection interface, untick the Locked option and click OK. Then right-click the worksheet and choose Format Cells in the context menu. Step 1: Press Ctrl+A to select all the cells in the Excel worksheet. And the locked cells only can be changed after entering the correct password for unprotecting the entire sheet. You can use this way when you need others to fill in your Excel worksheet, but want to keep some items like the form title be unchangeable. Lock Selected Cells with the Common Sheet Password Lock Certain Cells Using the Extra Range Passwordġ.Lock Selected Cells with the Common Sheet Password.So, what can you at this time? Here, we will talk about 2 useful ways to lock the selected cells in Excel 2016/2013/2010, let’s continue reading for more details. If you just want the certain cells to be locked, simply password protecting the worksheet can’t be applied. However, this way will lock all the cells in your worksheet. When you need to share an Excel worksheet with others, you might set a password to protect your worksheet from edit or modification.
0 kommentar(er)
