Hi there,

I work at a law firm and I have created a contact sheet which is a 2-page,
2-column table with Defendant's Contacts as the heading on the left side and
Plaintiff's Contacts on the right side. I have automated a macro using the
fillin field so that I can be prompted to add names and addresses into the
Defendant side of the table.

The problem is, we never have the same amount of contacts per case. So if I
had only 4 Defendant's Contacts, the Fillin field I programmed keeps going on
through the second page. I have to turn off each individual one. So I have 2
questions:

1. Is there a way to have the "cancel" on the fillin prompt dialog box
completely stop anymore fillin prompts from that point when I have reached
the limit of defendant's contacts?

2. Is there a way to then trigger new fillin prompts that go to the top
right of the page to fill out the Plaintiff's contacts and of course, stop it
when it is finished?

I'm not a pro at VBA so perhaps there are things I haven't even thought of
to accomplish this.