If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Protecting an excell workbook
I have a workbook which has 15 worksheets in it. It is on a network drive so
other people can access it. I want to allow people to view the workbook without having to enter a password but i dont want them to be able to edit it. Any suggestions on how I do this will be much appreciated Many Thanks cufc1210 |
#2
|
|||
|
|||
Protecting an excell workbook
Hi,
I would use Windows to do this. In Windows Explorer, right click the file and set it's property to read only. It won't stop people changing it but it will stop them saving with the same filename and given the level; or lack of, Excel security IMHO it's as good as any method. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "cufc1210" wrote: I have a workbook which has 15 worksheets in it. It is on a network drive so other people can access it. I want to allow people to view the workbook without having to enter a password but i dont want them to be able to edit it. Any suggestions on how I do this will be much appreciated Many Thanks cufc1210 |
#3
|
|||
|
|||
Protecting an excell workbook
EXCEL 2007
Take the following actions:- 1. Office Button (top left hand corner). 2. Save As 3. Click on the Tools drop down arrow in the lower right hand corner. 4. General Options . . . 5. General Options window should launch. 6. Enter a password in the:- Password to modify: - field only. OK Enter password again and hit OK again. 7. Save the file and close it. TO CHECK THE ABOVE HAS WORKED 8. Open the file again. 9. Password window should launch. 10. Select Read Only. 11. Try to amend the file and you will not be able to. Please hit Yes if my comments have helped. Thanks. "cufc1210" wrote: I have a workbook which has 15 worksheets in it. It is on a network drive so other people can access it. I want to allow people to view the workbook without having to enter a password but i dont want them to be able to edit it. Any suggestions on how I do this will be much appreciated Many Thanks cufc1210 |
Thread Tools | |
Display Modes | |
|
|