Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excell automatically protecting a ws | Excel Worksheet Functions | |||
auto locking of excell workbook (excell 2003) | Excel Discussion (Misc queries) | |||
Protecting a workbook | Excel Discussion (Misc queries) | |||
Excell-Protecting sheet formatting | Excel Worksheet Functions | |||
Protecting Workbook!.. | Excel Worksheet Functions |