ExcelBanter - Password protect

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Password protect (https://www.excelbanter.com/new-users-excel/172125-password-protect.html)

GeoSte

Password protect

How do I password protect a shared excel book so that people have read only
access but so thta I can have write access?

JP[_4_]

Password protect

This should work.

1. In your shared workbook, hit F12 to bring up the 'Save As' dialog
box.
2. Click ToolsGeneral Options
3. Enter a password to modify the file.
4. Don't share the password.

HTH,
JP

On Jan 8, 11:51*am, GeoSte wrote:
How do I password protect a shared excel book so that people have read only
access but so thta I can have write access?

All times are GMT +1. The time now is 10:41 AM.