ClearForm in Protected Form

[Sue]

I'm trying to add a Command Button that will clear my form while at the same
time being protected. Editing restrictions are Filling in Forms. The button
works when I turn protection off, but will not work while on.

I also want to hide the button during printing.

Can anyone help?

 

[Anne Troy]

Sue: Why not save your form as a template instead? When you're done, you can
close and not save. If you use the form a lot, you could record a macro in
your normal.dot file to close and reopen for you, and add a button to your
toolbar.
************
Anne Troy
www.OfficeArticles.com

 

[Sue]

I like the way the protected form works better than the template. This is
going to be widely used, and I want it as simple as possible to use. I'd
like the user to open the form and be able to tab to each field. I also have
a bunch of calculations invoved.

 

[Doug Robbins]

You mis-understand, the form containing the formfields can be a template.
Each time it is needed, you just create a new document from the template and
that process can be automated by the use of a macro. Then there is no need
to clear the fields in the form.

But, what are you doing with the data in the form?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Sue]

OK. So I can make the protected form itself a template? I'm still new at
this stuff, so I'll play with it a little bit. I never considered that.

For now I'm not doing anything with the data from the form. It's basically
fill in and print out. I want the user to be able to save the filled out
form as reference also.

 

[Anne Troy]

If you want them to save the form, then a template is DEFINITELY the way to
go. It will also keep users from overwriting your "original". When you
double-click a template, or hit File-New, and choose a template, "document1"
is created, see?
When I distribute templates to multiple people, tho, I tend to send it as a
doc and tell THEM to open it, then File-->Save as, DOT, making sure they
don't change the folder to which it wants to save by default. That way, you
don't have to go through all the bother of figuring out where their other
templates are located, etc. If you want multiple users on the same network,
tho, you can just store the template on a shared drive.
************
Anne Troy
www.OfficeArticles.com

 

[Charles Kenyon]

You definitely want a template of your online form. When you use the form,
you create a new document based on the template. That document can be filled
in and saved. Users will be forced to name the new document when they save
it. For more on the different kinds of templates, tabs on the file new
dialog, and locations of templates folders see
http://addbalance.com/usersguide/templates.htm.

What you are talking about is what Word calls an "online form." Check this
in help. For more about online forms, follow the links at
http://addbalance.com/word/wordwebresources.htm#Forms or
http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially Dian
Chapman's series of articles. You may also want to look at
http://www.word.mvps.org/FAQs/TblsFldsFms/LinesInForms.htm.

Hope this helps,
--

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


--------- --------- --------- --------- --------- ---------
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.