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
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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
