lock cell
 

I just want to lock the cell once date been entered. but only the certain
range and other cells I want to do the regular formats.

Thank you

lock cell
 

Hi ganga.

Please refer to:-

www.pierrefondes.com

The third item down on the home page is called:-

TWO FILES TO SHOW HOW TO PROTECT INDIVIDUAL CELLS FOR SMG201:-

The above is a fully worked example showing you how to protect individual
cells.

Please hit Yes if my comments have been helpful to you.

Thanks!



"ganga" wrote:

I just want to lock the cell once date been entered. but only the certain
range and other cells I want to do the regular formats.

Thank you