Uneditable selected Columns/Rows/Cells Excel

[Solved/Closed]
Report
-
 AD -
Hello,

Kindly teach me how to keep the slected [Column or Rows or set of Cells] in Uneditable Mode in Excel, so that users can not change the information on any specific area.

If there is Macro needs to be written, then the Macro should also be protected.

Kindly help.

2 replies

We appreciate the help provided.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You have to use sheet protection. Read excel help on sheet protection.