How to make cells not editable if it contains any data

**sthakkelapati** · #1 June 29th 12, 04:57 PM

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

**Gord Dibben[_2_]** · June 30th 12, 04:48 PM posted to microsoft.public.excel.newusers

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to make a worksheet Non-Editable even if extension is changed	Radha Krishnan[_2_]	Excel Programming	1	September 11th 09 12:09 PM
How to make combobox non-editable?	Yajiv	Excel Programming	1	February 25th 08 02:18 PM
How to make cell not editable	[email protected]	Excel Worksheet Functions	1	August 6th 07 09:11 AM
How do I make editable PDF forms using Excel?	Haplo	New Users to Excel	5	July 16th 06 12:09 AM
IS THERE A WAY TO MAKE AN OBJECT AN EDITABLE PART OF A SPREADSHEET	T[_2_]	Excel Programming	2	May 19th 04 10:16 PM