Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protection ??
I have documents on a shared network drive. Is there a way to protect a
workbook from being modified by anyone but me. Read only still gives anyone the chance to open it and modify it. Save As, Tools, password to modify still requires a password to open it at all. Others need to view only. Not edit. Appreciate any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protection ??
On Jan 2, 9:46*am, Terry wrote:
I have documents on a shared network drive. *Is there a way to protect a workbook from being modified by anyone but me. *Read only still gives anyone the chance to open it and modify it. *Save As, Tools, password to modify still requires a password to open it at all. *Others need to view only. *Not edit. *Appreciate any help. Use Protection under the Tools menu rather than in Save As. While not strong protection, it should stop most users. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protection ??
I have given it a password, but how does that kind of protection work?
"Spiky" wrote: On Jan 2, 9:46 am, Terry wrote: I have documents on a shared network drive. Is there a way to protect a workbook from being modified by anyone but me. Read only still gives anyone the chance to open it and modify it. Save As, Tools, password to modify still requires a password to open it at all. Others need to view only. Not edit. Appreciate any help. Use Protection under the Tools menu rather than in Save As. While not strong protection, it should stop most users. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protection ??
On Jan 2, 10:18*am, Terry wrote:
I have given it a password, but how does that kind of protection work? There are 2 choices, Worksheet and Workbook protection. They are separate and do different things. Worksheet allows you to stop any changes being made to the data. Leave all the cells Protected, which is the default state. There are options you can see in the window that pops up. Workbook protection allows you to stop them from creating/moving/ deleting sheets. I could sit here and type up everything it does, but easier for you to play with it, see what happens when you try to edit a cell or move a sheet with protection on. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protection ??
Thank you so much.
"Spiky" wrote: On Jan 2, 10:18 am, Terry wrote: I have given it a password, but how does that kind of protection work? There are 2 choices, Worksheet and Workbook protection. They are separate and do different things. Worksheet allows you to stop any changes being made to the data. Leave all the cells Protected, which is the default state. There are options you can see in the window that pops up. Workbook protection allows you to stop them from creating/moving/ deleting sheets. I could sit here and type up everything it does, but easier for you to play with it, see what happens when you try to edit a cell or move a sheet with protection on. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protection ??
Hi,
Although its true that Read Only (with a password) still allows other users to modify the worksheet, they can't save it back over the original file. So in effect the original file is protected from modifications. If that is good enough, you don't need sheet protection. But if you use sheet protection remember that it must be turned on for each sheet. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Terry" wrote: I have documents on a shared network drive. Is there a way to protect a workbook from being modified by anyone but me. Read only still gives anyone the chance to open it and modify it. Save As, Tools, password to modify still requires a password to open it at all. Others need to view only. Not edit. Appreciate any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protection | Excel Discussion (Misc queries) | |||
WS Protection: Different Levels of Protection on Different Ranges | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) | |||
Protection | Excel Discussion (Misc queries) |