How to make cells not editable if it contains any data
 

Hi,

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

I am very new to VB programming. Please suggest.

Thanks,
Srihari Thakkelapati

How to make cells not editable if it contains any data
 

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

http://groups.google.com/group/micro...uthor:dib ben

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


Gord


On Fri, 29 Jun 2012 15:57:47 +0000, sthakkelapati
wrote:


Hi,

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

I am very new to VB programming. Please suggest.

Thanks,
Srihari Thakkelapati