How to Lock a Spreadsheet?

[Excel_77]

Hi All,

How do I lock a spreadsheet so that when it's selected to open a password has to be inserted and the only other option is to access the spreadsheet is a read only format?

Thanks

 

[Rijnsent]

Hi Excel77,
do you mean worksheet or workbook? For workbook this tutorial is a help: Password Protect a Workbook in Excel - EASY Excel Tutorial
For worksheet, see this tutorial (it's a bit more complex and requires some VBA): https://www.ablebits.com/office-addins-blog/2016/02/10/protect-unprotect-excel-sheet-password/
Cheers,
Koen