View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default 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