Finally, the last set of protection we need to consider is whether we need a password to modify the workbook or to open the workbook. If the IT Department puts it into a secure location without a password, it means if something happens to you in the future, the IT Department will still be able to recover your work. The Password Excel Spreadsheet should be put in a secure location by your IT Department with no password on the individual file. Keep in mind you need to be documenting these passwords in a separate workbook in a secure location on your server. You can also enter another password as well. The application will then allow you to protect the structure and windows. You can do this by going to the Tools menu, choosing Protection and the choosing Protect Workbook. The previous examples protected the individual worksheet but you also need to be able to protect your workbook. One of the other elements you can protect is the ability to change the workbook. The reason that Microsoft has done this is to ensure that you can have different people modifying the data on differing worksheets, rather then each person being able to modify everything. If you have multiple worksheets in your spreadsheet you will have to go to each individual sheet and protect them. 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)
