+ Reply to Thread
Results 1 to 2 of 2

lock cell and/or message box after user enters data?

  1. #1
    Registered User
    Join Date
    11-25-2014
    Location
    Lincoln, UK
    MS-Off Ver
    2010
    Posts
    19

    lock cell and/or message box after user enters data?

    Morning,

    I have a request log with data that needs to be protected once entered as it is 'signed off' so must not be able to be changed once signed.

    Is anyone able to offer some coding that looks to check that once 'signed' the data in the cells of that row cannot be edited and/or a message box pops up advising unable to edit?

    I have used various codes below to get parts of what I want but nothing to check against the signature cell?

    Message Box:

    Please Login or Register  to view this content.
    Locking cells/sheet:

    Please Login or Register  to view this content.
    Any help would be great!

    many thanks

  2. #2
    Registered User
    Join Date
    11-25-2014
    Location
    Lincoln, UK
    MS-Off Ver
    2010
    Posts
    19

    Re: lock cell and/or message box after user enters data?

    p.s my signature cells are part of a name range "Signature", columns L-N, P-Q.

    all other cells which need to be locked once signed, are in columns A-K, also named as a range if needed "Data"

+ 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. Replies: 5
    Last Post: 06-22-2014, 08:27 PM
  2. Popup message showing adjacent cell value when user enters value in cell
    By kevinkusman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2013, 12:21 PM
  3. [SOLVED] How to pop up message when user enters any text in TextBox. Should be enter by number only
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-21-2013, 02:26 AM
  4. Replies: 0
    Last Post: 10-30-2012, 03:48 PM
  5. [SOLVED] MsgBox popup when user enters a value in a cell
    By okelly in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-26-2012, 01:00 PM
  6. Replies: 2
    Last Post: 08-06-2008, 02:09 PM
  7. [SOLVED] How to run a macro when user enters a value in a cell?
    By serdar in forum Excel General
    Replies: 5
    Last Post: 06-05-2005, 09:40 PM

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