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?