+ Reply to Thread
Results 1 to 5 of 5

Restrict editing

  1. #1
    Registered User
    Join Date
    11-28-2014
    Location
    india
    MS-Off Ver
    7
    Posts
    139

    Restrict editing

    Hi All
    Just wanted to know how I should disable one row for edit.

    The requirement is for a few of the fields of an excel sheet I wanted to restrict editing.
    If anyone can help me out with this.

  2. #2
    Registered User
    Join Date
    11-28-2014
    Location
    india
    MS-Off Ver
    7
    Posts
    139

    Re: Restrict editing

    Please note that the restriction should be activated post first entry.

    Once I entered something in the blank field after that no editing cannot be made.

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Restrict editing

    After entered some field, you do to protect.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Registered User
    Join Date
    11-28-2014
    Location
    india
    MS-Off Ver
    7
    Posts
    139

    Re: Restrict editing

    Ya I want to do that autometically

  5. #5
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,892

    Re: Restrict editing

    You need VBA
    I am not familiar with vba, kindly post in Excel Programming / VBA / Macros

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Editing data by selecting it in one userform and editing in another userform.
    By (T_T) in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-25-2020, 12:41 PM
  2. User Form - Many Text Boxes - Restrict One Text Box with Password for Editing
    By kavi.sundar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2019, 07:42 PM
  3. Replies: 3
    Last Post: 06-15-2017, 05:23 AM
  4. [SOLVED] Restrict Manual Editing of Spreadsheet
    By minimitts in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-29-2015, 11:23 AM
  5. Replies: 1
    Last Post: 08-07-2014, 12:32 AM
  6. [SOLVED] how to restrict editing a worksheet after finalising inputs?
    By jetlee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-04-2014, 03:24 PM
  7. Restrict editing in form to a given area
    By TomBP in forum Word Formatting & General
    Replies: 1
    Last Post: 02-17-2013, 06:47 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1