Enable editing for certain users / set password for editing

Hello dear Excel-users!

I have a workbook that I would like all in my organization to be able to view. However I just want few of my colleagues to be able to edit the workbook. I have absolutely no clue how to manage this in a good way.

The ideal way would like to set a password for editing and if you enter the password you've editing access. If you dont enter the password you have view access.

Would very much appreciate your help,
Thanks!
CJ

When you save your workbook there is a drop down called Tools next to the Save button. Click that and select General Options.

Options.png

Enter a password in 'Password to modify'.

This will enable all users to view the file as read only, but those with access to the password will be able to write to the file.

Hello MrChipper,

Thank you for your answer. Unfortunately I really cannot find that "General options". What Excel version are you using? Im using 2016. Is that solution permanent so you will have a password set permanently all time you're opening the workbook?

Thank you!!!

This is the Save As dialogue box. General Options is accessed by clicking on Tools, next to the Save button.

Save As.png