Prevent data being deleted after Enter & Save

I am creating a simple workbook with 4 possible entry categories; Date, Cash In, Cash Out, Comment.
What I need is to have the data automatically posted to the next blank line when entered, and not permit deletion. I need to do this to avoid any of the committee members trying to modify the books to help their wallets. Is there a simple way of doing this or am I looking at some complicated VBA?

Hi,

No the VBA isn't complicated. But of course the most you can do is protect the worksheet with a password. Which is fine for non teccy/VBA gurus, but there are hacks out there which will crack Excel passwords, so ultimately it's not safe.

What you need to do is.

1. Name your 4 cell entry range say "Input"
2. Format all four cells so that they are NOT locked
3. Add a button which will run the 'AddRecord' macro
4. Password protect the worksheet
5. Add the following macro - note it assumes the new entry goes into the next available cell in column A

Please Login or Register  to view this content.

6. Now in the VBE (macro) environment, from the menu choose Tools, VBA Project Properties, Protection Tab - and select the 'Lock Project for Viewing and add a password. This will hide the VBA code above from someone who knows about VBA.

Then your users can just enter data and click the 'Add Record' button.

Hi Unca Wook,

These event codes might do the trick on a protected or unprotected sheet:

Please Login or Register  to view this content.

Please Login or Register  to view this content.