Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Locking Drop Downs In Word Once Complete

Status
Not open for further replies.

SamDemon

Technical User
May 28, 2003
171
GB
I have created a Word document with drop down lists. Is it possible for word to lock these once they have been chosen so that the client can not change them once they have been sent out?

Rgds

Sam

It's just common sense, shame sense isn't common!
 
When the document is complete, the form must be unlocked, and then do Control A, Control Shift F9

HTH
Joanne
 
would this be possible using a macros / creating a button on the word toolbar?

It's just common sense, shame sense isn't common!
 
Sure - or even easier - have a macro run when the user exits the last formfield:

Sub UnlinkFields()
If ActiveDocument.ProtectionType <> wdNoProtection Then
ActiveDocument.Unprotect Password:=&quot;&quot;
End If
Selection.WholeStory
Selection.Fields.Unlink
Selection.HomeKey
End Sub
 
That's brilliant but the following message comes up after i tab off the last field:-

The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros.

Excuse my stupidity but i cant find out where or why these are disabled.

Sam

It's just common sense, shame sense isn't common!
 
What version of Office/Word are you running?

If it's 2000, you need to go to Tools, Macro, Security, and then put it on low I believe...don't have it in front of me.

 
that worked thanks


It's just common sense, shame sense isn't common!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top