Want to protect, but not lock for viewing

W

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?
 
J

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?
Click to expand...

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
[email protected]
Word MVP site: http://www.word.mvps.org
 
Top