Hello....I want to create a Macro that would do the following:

If the row above it (some specific cell) contains data, I want Excel to automatically add a row below it. This would be similar to what Access does. I want to do this so that a user can enter information into a protected sheet without having to unprotect it, add the rows, and reprotect it. This will cut down errors. Can anyone help?

Thanks!