Thank you, I think I'm really stuck because I am a beginner, and the VBA is overwhelming. You all are correct regarding the protected document piece, but how do I make this work? I see code that is close, but it is a little bit complicated to figure out how to alter the code to get it to work with my particular document.
Here's what I have:
1. Created a form template that is supposed to be protected. (Or can some fields only be protected, so that they can fill out the necessary parts?)
2. Content controls in the fields
What it needs to do:
1. Restrict users from making unnecessary changes to the document
2. User needs to enter data in fields (which are content controls)
3. *** This is where I need the most assistance *** When the user hits the enter key or tab key on the field at the end of the row, it needs to create a new row with all the fields (including the content controls), so that if the user needs to enter new information for that line, they can do so, and it will be set in format.
Please help.
Thank you.
|