How to make cells not editable if it contains any data

[sthakkelapati]

Hi,

I have created a 2010 macro enabled excel. I want the cells once entere
to be uneditable. Only administrator should be able to change the value
in the cell. I am expecting a VB macro code for this.

I am very new to VB programming. Please suggest.

Thanks,
Srihari Thakkelapat

 

[Gord Dibben]

Check out this thread to see if you want to work with something like
it.

http://groups.google.com/group/micr...3e76b5eb?q=justme+group:*Excel*+author:dibben

Note the warnings about Excel's weak security and other issues that
could arise.


Gord