ExcelBanter - Security Settings

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Security Settings (https://www.excelbanter.com/excel-worksheet-functions/154337-security-settings.html)

Alex Mackenzie

Security Settings

What is the correct security setting to allow someone to only enter data into
cells? Read & Execute or do they need Write or Modify? This is for a shared
worksheet on a global network drive; spreadsheet is accessed through a
hyperlink. Currently only Read & Execute, but users get a warning it is Read
Only. Thank you.

Gary''s Student

Security Settings

Protect individuals cells containing formulas
--
Gary''s Student - gsnu200737

"Alex Mackenzie" wrote:

What is the correct security setting to allow someone to only enter data into
cells? Read & Execute or do they need Write or Modify? This is for a shared
worksheet on a global network drive; spreadsheet is accessed through a
hyperlink. Currently only Read & Execute, but users get a warning it is Read
Only. Thank you.

Harlan Grove[_2_]

Security Settings

"Gary''s Student" wrote...
Protect individuals cells containing formulas

Cells are locked by default. OP needs to protect WORKSHEETS.

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