How to protect Workbook from Editing

Copper Contributor

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? @Jan Karel Pieterse 

I've attached a gif to my previous reply.

@BeachITguy 

Exactly the same, just another way to set (File->Info->...)

image.png

Thank I am testing it out now.@Jan Karel Pieterse