+ Reply to Thread
Results 1 to 4 of 4

Allow users to enter data but prevent user from deleting data once entered

  1. #1
    Registered User
    Join Date
    02-07-2014
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    21

    Allow users to enter data but prevent user from deleting data once entered

    Good Evening,
    I am working on a spreadsheet for users to have the ability to enter data but not remove it once it's entered. They will need to be able to enter data into multiple cells. The current code below is what I have started with, but it is not working. Any help would be greatly appreciated.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Allow users to enter data but prevent user from deleting data once entered

    Something like this...
    Place the below code on Sheet Module.
    Please Login or Register  to view this content.
    Does this help?
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    02-07-2014
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Allow users to enter data but prevent user from deleting data once entered

    sktneer,
    This worked perfectly in my test piece. Thank you so very much. Since we are trying to protect all entries by staff member, is it possible to prevent the worksheet itself from being deleted as well?

    Thank you kindly,
    Chgardne

  4. #4
    Registered User
    Join Date
    02-07-2014
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Allow users to enter data but prevent user from deleting data once entered

    I added worksheet protection. I forgot about that.

    Thank you again for your help. This has solved my issue.

    Chgardne

+ 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. How to prevent users from deleting Sheets
    By var in forum Excel General
    Replies: 3
    Last Post: 06-18-2012, 04:22 PM
  2. Prevent Users From Deleting Worksheets
    By Spencer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2011, 03:39 PM
  3. How to prevent user from deleting and shifting data
    By Tiresidedown in forum Excel General
    Replies: 2
    Last Post: 02-09-2010, 08:12 PM
  4. How to prevent users from deleting tabs
    By moike in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2006, 10:52 AM
  5. Replies: 0
    Last Post: 04-17-2005, 04:06 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