Chukesgirl
08-04-2008, 05:15 PM
I have a template form that is protected. In the form there is a text box control (which is in a table because there can be more than one address) for the user to insert an address. I need the user to be able to create an envelope from that address text box. I would like a macro that will do the folllowing things after the user has put his cursor on the address:
1. unprotect the document
2. select the cell with the address in it and copy it
3. create the envelope
4. add the envelope to the document
5. re-protect the document
6. As a bonus, it would be nice if it would print the whole thing, but not necessary.:help
1. unprotect the document
2. select the cell with the address in it and copy it
3. create the envelope
4. add the envelope to the document
5. re-protect the document
6. As a bonus, it would be nice if it would print the whole thing, but not necessary.:help