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....
|