Jun 24 2020 06:18 AM
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.
Jun 24 2020 06:49 AM - edited Jun 24 2020 07:04 AM
You can set the workbook to be read-only, unless the user enters a read-write password (optional), would that work?
Jun 24 2020 06:52 AM
That might work.. How would I go about setting that option? @Jan Karel Pieterse
Jun 24 2020 07:05 AM
Jun 24 2020 07:17 AM
Jun 24 2020 07:46 AM
Thank I am testing it out now.@Jan Karel Pieterse