Forum Discussion
How to protect Workbook from Editing
Hello,
I have a strange situation where I need to protect a workbook from editing but would like to keep it so that it is still viewable without a password. I know that you can protect locked cells on a particular worksheet, but the document I am working with has about 100 different sheets in it. Is there a way I can protect all the sheets from being edited? Without, needing a password to open the workbook?
Thank you.
5 Replies
You can set the workbook to be read-only, unless the user enters a read-write password (optional), would that work?
That might work.. How would I go about setting that option? JKPieterse
