Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 29th 12, 04:57 PM
Junior Member
 
First recorded activity by ExcelBanter: Jun 2012
Posts: 1
Default 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

  #2   Report Post  
Old June 30th 12, 04:48 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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 03: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


All times are GMT +1. The time now is 10:22 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017