Results 1 to 10 of 10

VBA : Lock column after data entry

Threaded View

  1. #1
    Registered User
    Join Date
    07-30-2013
    Location
    London UK
    MS-Off Ver
    Excel 2007
    Posts
    8

    VBA : Lock column after data entry

    Hi everyone

    I'm trying to setup a spreadsheet where after typing in the name and selecting all the fees it would automatically lock the column
    so the user wouldnt be able to go back and change the name or the fees again after inputing them for the first time.

    So lets say i type new name in A3, I select all the fees i want to then i proceed to A4 with a different name, and at this point I should be unable to change anything in A3 but
    the program wouldn't lock me out from inputing other users in other columns until they filled.

    I found a bunch of other similar topics on that subject like :

    http://www.excelforum.com/excel-prog...ific-cell.html

    http://www.excelforum.com/excel-prog...a-entered.html

    But the only problem I have with those solutions is that they are locking down the rows as well.

    Any idea how can i lock them ?

    I've attached the spreadsheet to the post if you want to have a look

    Any help would be appreciated.

    Cheers
    Attached Files Attached Files
    Last edited by z0mg; 07-30-2013 at 01:20 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] to lock the cell after data entry
    By sbehera in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2013, 05:49 AM
  2. How can I lock a cell after data entry
    By sribeiro in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-02-2013, 10:21 AM
  3. lock cells after data entry
    By aleenkhan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2012, 03:14 AM
  4. lock cell after data entry
    By Jim St. Martin in forum Excel General
    Replies: 1
    Last Post: 03-17-2005, 08:06 PM
  5. lock cell after data entry
    By shree58 in forum Excel General
    Replies: 0
    Last Post: 02-14-2005, 01:51 AM

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