Lock the field Value on Leaving the Sheet

[alvinford]

Hi All,

I want to lock a field value on leaving a sheet .

I have the following data ..

Load * inline [

User

A

B

C];

When ever I leave the sheet i want to lock the B value of the Field user . I tried the sheet triggers but not successful . Hope this is achieved using the macro.

Please guide me.

[#2]

Hi, try this macro :

Sub Lock_User
ActiveDocument.Fields("User").Select "B"
ActiveDocument.Fields("User").Lock
end sub

Once the maccro is ready, you have to configure the trigger from the sheet properties, adding the macro on the 'leave sheet' event.

greetings