It also means they can use the tab key to go from one Unprotected Cell to another. If you deselect this option it means only the Unprotected cells can be selected by your users. The main one we are concerned about is deselecting the option Select Locked Cells. You also have some other options available in the Protect Sheet dialog box.
If you enter a password, make sure that you make a note of it because if you don't and you forget the password, you will have problems reusing this sheet or in particular changing this sheet in the future. Now, this is where you need to be very careful. At this point the Protect Sheet dialog box will appear and will ask you to enter a password. So, now choose the worksheet you want to protect then go to the Tools menu and choose Protection from the drop down menu, and then finally choose Protect Sheet. Now the interesting thing about this is that to enable protection of the cells you must individually protect each worksheet. The next step once you have completed this process is to protect the worksheet. So at this point you need to go through and follow this process for all the cells that you want to have your staff entering data for. To complete the process simply choose the OK button. That means we need to deselect it by clicking on the check box once. This tick means that when you set protection for this worksheet it will not be available for editing. You will now see a check box that says Locked and it should have a tick next to it. In the Format Cells dialog box simply choose the Protection tab. So, to protect and unprotect cells, the first step is to select the cells that you want to unprotect, then select the Format menu and choose Cells from the drop down menu, alternatively you could have used the shortcut keystroke +. By default, every cell in Microsoft Excel is setup with the cells being protected however, the function is not enabled until you actually protect the worksheet. The first step you must take in protecting your workbook in Microsoft Excel is in deciding what cells you want to protect.
The reason I have chosen this version is that it provides far more security options compared to previous versions. My outline in this article will cover setting up protection for Microsoft Excel 2003. You can even control which cells they can click on and which ones they can't. That's right, you can control what people can modify. Why not lock off the cells you do not want your staff to be playing with. Well, here a couple of things to consider. Now if you are like me, this can be a major task and a major source of frustration, in particular because you will have some people in your team that will know better and want to modify your templates. For example, if you are working in a large corporation and you are a Senior Manager, one of the responsibilities you will have is to create budgets each year.
0 kommentar(er)
