Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Reserving Excel documents
How does a person "reserve" documents to where a password is required in
order to change data? I used to know this.... |
#2
|
|||
|
|||
Hi Jen
there's basically three ways you can put a password on an excel document 1) to open it (file / save as / click tools - general options - password ... this allows you to set a password to open and / or a password to modify) 2) password protection set on a sheet by sheet basis (tools / protection / protect sheet) ... this allows you to limit the cells the people can change (need to "unlock" the cells you want them to get to first - format / cells / protection - untick locked) 3) password protect the structure of the workbook (tools/ protection / protect workbook) this stops them inserting or deleting or renaming sheets hope this helps cheers JulieD "Jen" wrote in message ... How does a person "reserve" documents to where a password is required in order to change data? I used to know this.... |
#3
|
|||
|
|||
Thank you!!
"JulieD" wrote: Hi Jen there's basically three ways you can put a password on an excel document 1) to open it (file / save as / click tools - general options - password ... this allows you to set a password to open and / or a password to modify) 2) password protection set on a sheet by sheet basis (tools / protection / protect sheet) ... this allows you to limit the cells the people can change (need to "unlock" the cells you want them to get to first - format / cells / protection - untick locked) 3) password protect the structure of the workbook (tools/ protection / protect workbook) this stops them inserting or deleting or renaming sheets hope this helps cheers JulieD "Jen" wrote in message ... How does a person "reserve" documents to where a password is required in order to change data? I used to know this.... |
#4
|
|||
|
|||
you're welcome
"Jen" wrote in message ... Thank you!! "JulieD" wrote: Hi Jen there's basically three ways you can put a password on an excel document 1) to open it (file / save as / click tools - general options - password ... this allows you to set a password to open and / or a password to modify) 2) password protection set on a sheet by sheet basis (tools / protection / protect sheet) ... this allows you to limit the cells the people can change (need to "unlock" the cells you want them to get to first - format / cells / protection - untick locked) 3) password protect the structure of the workbook (tools/ protection / protect workbook) this stops them inserting or deleting or renaming sheets hope this helps cheers JulieD "Jen" wrote in message ... How does a person "reserve" documents to where a password is required in order to change data? I used to know this.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
Opening an Excel file | Excel Discussion (Misc queries) | |||
Excel quits responding searching for files not in my documents | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |