Urgent help needed

K

Khoi

Whenever I unprotect a document another user protected (without a password),
form fields get reset and become blank and I must re-enter the data. Any
switch somewhere I can turn on (or off) to prevent this? These docs are
created from .dot with fields to enter data mostly dates.
 
K

Khoi

Thanks. I visited that page before posting this question. I am using Office
2007, not any of the version mentioned on that page.
 
K

Khoi

I got this from WordMVP but don't know if you want me to edit the
ToolsProtectUnprotectDocument command OR create a new AddIn? I don't know
how to do either one.
Besides, why does all this happen in the first place making things unduly
difficult for users?
 
K

Khoi

I am still totally lost. Please answer these questions:
#1. Should I open and edit ToolsProtectUnprotectDocument command OR shoud I
create a new AddIn?
#2. If the latter, is an Add-In the same as a macor? A VB or a module?

I did an Alt F8 and found ToolsProtectUnprotectDocument macro but the Edit
button is dimmed and disabled.
 
S

Suzanne S. Barnhill

I suspect that you should not be meddling with this. Find someone else
(local) who is capable of understanding the instructions and ask for help.
 
B

Bob Buckland ?:-\)

Hi Khoi,

For the type of form you're using Word has two 'modes', design-a-form and fill-in-a-form.

When the document is 'protected for forms' you're in 'fill-in' (i.e. you can only type in designated 'blanks' for your form. Cancel
the 'protection' and you're in design mode.

- You can change the 'design' of the form (i.e. it's a regular Word document).
- The data already in that copy of the form is cleared as it's no longer a form.

When you protect the form from the Toolbar/Menu you're using a Word built in toggle command named
ToolsProtectUnprotectDocument
Normally, using that works as described above.

The [Edit] button being greyed out is from trying to 'edit' an existing Word built in command, rather than a macro. One method to
change the way a Word command works is to reuse the name of a built in command as the name of a macro, You can then change the
'steps' Word follows when you run the command by keyboard shortcut or clicking on it, basically, you're revising Word's 'response'
to your request for a specific action.

This is what is addressed in the article previously mentioned by Jay in
http://word.mvps.org/FAQs/MacrosVBA/TurnFmFlfResetOff.htm
It addresses several different scenario possibilities, but the idea is to tell Word to not erase the previously typed data when you
'unprotect' the document.

The differences in where you store the 'rethinking' within an 'Add-in' (Alt, T, I), the forms underlying .DOT template, or in the
specific document that holds the form is basically giving you the option on whether you want to change Words 'new rule' to apply,
based on where you store the 'macro' (Word command replacement)

- Store in a document to have it work only in a specific document

- Store it in the form template to change the rule for all 'forms' created from a specific Form .dot (template file)

- Store it in an Add-in template to change the rule when the 'Add-in' is 'Attached' and active (Alt, T, I), even if the template
or document don't, themselves, have the macro.

What the first changed command is doing is changing the default behavior of the Word command with this part of the macro
noreset = True
That's the part that keeps Word from blanking out the previous data.

================
I am still totally lost. Please answer these questions:
#1. Should I open and edit ToolsProtectUnprotectDocument command OR shoud I
create a new AddIn?
#2. If the latter, is an Add-In the same as a macor? A VB or a module?

I did an Alt F8 and found ToolsProtectUnprotectDocument macro but the Edit
button is dimmed and disabled. >>
--

Bob Buckland ?:)
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top