I would like to run a macro on a protected form.
Here's what I would like to do...
I have a label sheet which have form fields in them. The sheet is 2 wide by 15 high. As soon as I'm done entering form protected info on 2 labels in a row (left label=name , right label= address) I would like the macro to do the following...
1. Unprotect the form fields
2. Erase ONLY the text entered in the form fields
3. Cut all the form fields in Left label row 1 and right label row 1
4. Paste the form fields into Left label row 2 and right label row 1
5. Protect the form field again and be ready for next name and address input.
Is this possible?
Thanks in advance