macro doesn't work when I unprotect form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mary - 03 May 2005 17:40 GMT

I have a text form field that runs a macro on entry.
This macro shows a userform, when you click on print,
labels are supposed to print, based on a macro I've
written with mail merge, etc. The macro works when the
form is protected and I run it from Tools-Macro, but when
I unprotect the form I can't run the macro. What am I
doing wrong? I'm using Microsoft Word 2002. Thanks!

Reply to this Message

Charles Kenyon - 03 May 2005 19:35 GMT

By definition, an on-entry macro is not going to run in an unprotected
document because there is no "entry." The formfields are not active in an
unprotected document.

If your macro unprotects the document, trying to run it on an unprotected
document may generate an errror. You might want to post your code in one of
the vba newsgroups for help with it.

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

>I have a text form field that runs a macro on entry.
> This macro shows a userform, when you click on print,
[quoted text clipped - 3 lines]
> I unprotect the form I can't run the macro. What am I
> doing wrong? I'm using Microsoft Word 2002. Thanks!

Reply to this Message