How to protect a workbook in Excel so that a password is required to open, either as a read only or to make adjustments
Excel has the capabilities to protect workbooks so that certain passwords only allow viewing and other passwords allow changes.
For example, here we have a workbook that we want to protect. In order to do that we click on FILE , SAVE AS, and the normal dialogue box will appear. But for this option you need to go to the tools, GENERAL OPTIONS tab, and you will be asked to input a password. As you can see, it asks you for a password that will allow someone to open the file, and the password that will allow you to modify a file. So in here we are going to use the password open, and for modify we are going to use the password modify. When you click OK you are told to re enter the password to proceed, you will put in the open password , click OK, the password to modify is modify, click OK, and now when you save it, it will be saved with the password protection enabled.
Now we will click YES. We now going to close it down and let us open it up again and see what happens. Now you will see it says it is protected and you need to provide a password to read it. So we will use our open password, and say OK. It mentions that it is read only unless you have the password to modify it in which case we can type in modify, or we could click on read only if we only wanted to read it. We will say OK.
Now you have access to your workbook and you can make the changes you require.
If I understand the query below correctly, the one idea is to type some words in a cell, and then, while holding the ALT key down, click ENTER. Within the cell you will get another line. Hope this helps. Original query Hi, … Continue reading
A recent email query asked how to share and unshare workbooks in Microsoft Excel with a specific focus on switching off the sharing. The method to share and ‘unshare’ the workbook is the same. As shown in the image below, … Continue reading
We have used Audit Excel/Miracle Solutions for all our Excel training requirements for the past 18 months, the assessment is a good tool to determine that the trainee is allocated to the correct training.– KRONES Lifecycle Service Center Africa