ExcelBanter - Lock cell

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Lock cell (https://www.excelbanter.com/excel-programming/309103-re-lock-cell.html)

mangesh_yadav[_96_]

Lock cell

click on format cells protection
check the box 'Locked'
click on Tools protection protect sheet

this will lock your formula

Mangesh

---
Message posted from http://www.ExcelForum.com/

Dave Peterson[_3_]

Lock cell

Use this to check your linked cell, too!

(for mangesh_yadav--not the OP.)

"mangesh_yadav <" wrote:

click on format cells protection
check the box 'Locked'
click on Tools protection protect sheet

this will lock your formula

Mangesh

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

All times are GMT +1. The time now is 12:57 AM.