Want to protect, but not lock for viewing

[Widge]

Hi there, for ask field purposes, I've needed to create a lock
function that locks the sheet but does not refresh the fields. So
using this:

ActiveDocument.Protect _
Type:=wdAllowOnlyFormFields, NoReset:=True,
Password:="pfhlock"

The only problem is, this is inserting a "lock for viewing" password
too. This is to be sent out for people to update certain fields but I
don't want to have to provide them with a password because this will
unlock the entire sheet.

How can I get around this?

 

[Jean-Guy Marcil]

Widge was telling us:
Widge nous racontait que :

Hi there, for ask field purposes, I've needed to create a lock
function that locks the sheet but does not refresh the fields. So
using this:

ActiveDocument.Protect _
Type:=wdAllowOnlyFormFields, NoReset:=True,
Password:="pfhlock"

The only problem is, this is inserting a "lock for viewing" password
too. This is to be sent out for people to update certain fields but I
don't want to have to provide them with a password because this will
unlock the entire sheet.

How can I get around this?

I am not sure I follow. You are using code designed to protect a document so
that only formfields can be modified, but you do not want the protection?

Can you elaborate?

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org