ExcelBanter - Protections

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

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

- - Protections (https://www.excelbanter.com/excel-worksheet-functions/170878-protections.html)

tonyalt3

Protections

I only want users to be able to enter data in a few cells of a
worksheet, how do I go about doing this?

Noob Jedi

Protections

On Dec 27, 1:34*pm, tonyalt3 wrote:
I only want users to be able to enter data in a few cells of a
worksheet, how do I go about doing this?

Tools, Protection, Allow Users To Edit Ranges...

Should be self explanatory from there. When you protect the sheet,
it'll lock down all cells not included in your selected ranges.

All times are GMT +1. The time now is 08:36 AM.