Results 1 to 1 of 1

Protecting the cells once the data input is completed

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2014
    Location
    Sydney
    MS-Off Ver
    2010
    Posts
    9

    Protecting the cells once the data input is completed

    Gentlemen (and madams!),

    I am setting up a database with Excel (probably not the best software to do that), and I would like to make it "bulletproof", considering that other people may use it.

    It is a file that will be upgraded with additional data from time to time, keeping unmodified the data previously entered. Data will be filled in from row to row (starting from row 1 up to...an indefinite number for the moment). What I would like to do is, once the row has been duly compiled, put a button at the end of the same row to "lock the cells" and avoid any further, accidental or undesired modification.

    For example. I have to fill out row#1 : I insert all the data (from column A to column M). I would like to have a button, in cell N1, that once clicked by the operator, locks all the previous cells, from A1 to M1.
    Same in row 2, 3, 4... and so on. I guess I have to use a Macro, but I have no idea about hot to set it up.
    This way, with the subsequent file access, there is no chance to accidentally modify the previously inputed data. Should we require to manually modify the cell afterwards, we may unlock the file in the normal way (review --> remove protection).

    Any idea ?

    [EDIT]

    Even a floating button, that stands somewhere under the last row compiled, would be perfect....
    Last edited by Starflex; 08-27-2014 at 01:15 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Hyperlink to Hidden tabs then hide again after completed data input.
    By Toli in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-22-2012, 07:31 PM
  2. Protecting cells - Input through a UserForm
    By sgp in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-13-2011, 02:43 AM
  3. Replies: 3
    Last Post: 10-12-2009, 12:50 PM
  4. restarting a script after user input is completed
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2008, 09:58 AM
  5. Protecting Cells AFTER Data is entered.
    By kmd in forum Excel General
    Replies: 3
    Last Post: 02-06-2006, 06:55 PM

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