Password Protect so can't save and change

B

Brandy

Is there a way to password protect (for modify) an original worksheet/book,
so that if someone opens it and chooses 'save as', it still won't let them
make any changes?
I have a workbook that was not password protected but that had incorrect
information in it. Someone saved it as a copy, made some format changes and
posted it for others to use, however, again, it still has wrong information
in it because only the original was fixed. How can I protect the original,
so that any 'saved' copies will still require a password to modify?
 
B

Bruce Sinclair

Is there a way to password protect (for modify) an original worksheet/book,
so that if someone opens it and chooses 'save as', it still won't let them
make any changes?
I have a workbook that was not password protected but that had incorrect
information in it. Someone saved it as a copy, made some format changes and
posted it for others to use, however, again, it still has wrong information
in it because only the original was fixed. How can I protect the original,
so that any 'saved' copies will still require a password to modify?

Be warned that even the "protection" you want (no I don't know how to do
that, sorry :) ) is very little protection indeed. Excel protection
is very limited. Sometimes a copy/paste will reveal hidden columns (for
example) ... and there are many password removers out there. You are
protecting against beginner users and honest people only. :)
 

Ask a Question

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.

Ask a Question

Top